|
|
|
|
|
|
|
|
CurrentWorksheet (Property) In french: FeuilleEnCours
The CurrentWorksheet property is used to get and change the current worksheet in a Spreadsheet control.
// 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 control>.CurrentWorksheet
<Result>: Integer Position of the current worksheet. <Spreadsheet control>: Control name Name of the Spreadsheet control to be used.
Modifying the current worksheet in a Spreadsheet control Hide the details
<Spreadsheet control>.CurrentWorksheet = <New value>
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <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 Spreadsheet control management functions always handle the data in the current worksheet.
- The syntaxes for accessing the cells always handle the current worksheet.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|