PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..CurrentWorksheet is used to find out and modify the current worksheet in a Spreadsheet control.
Example
// Add a worksheet
nWorksheet is int
nWorksheet = SpreadsheetAddWorksheet(PSHEET_MySpreadsheet)
// Select the worksheet
PSHEET_MySpreadsheet..CurrentWorksheet = nWorksheet
Syntax

Finding out the position of the current worksheet Hide the details

<Result> = <Spreadsheet>..CurrentWorksheet
<Result>: Integer
Position of the current worksheet.
<Spreadsheet>: Character string (with or without quotes)
Name of the Spreadsheet control to use.

Modifying the current worksheet in a Spreadsheet control Hide the details

<Spreadsheet>..CurrentWorksheet = <New Value>
<Spreadsheet>: Character string (with or without quotes)
Name of the Spreadsheet control to use.
<New Value>: Integer
Position of the worksheet that will become the current worksheet.
Remarks
  • If the Spreadsheet control does not manage the multiple worksheets:
    • the modification of the current worksheet has no effect,
    • the position of the current worksheet is always set to 1.
  • The functions for managing the Spreadsheet control always handle the data found in the current worksheet.
  • The syntaxes for accessing the cells always handle the current worksheet.
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment