ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
The CurrentWorksheet property gets and sets the current worksheet in a Spreadsheet control.
Example
// Ajout d'une feuille de calcul
nFeuille is int 
nFeuille = SpreadsheetAddWorksheet(TBLR_MonTableur)
// Sélection de la feuille de calcul
TBLR_MonTableur.FeuilleEnCours = nFeuille
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 functions always handle the data in the current worksheet.
  • The syntaxes for accessing the cells always handle the current worksheet.
See also
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/20/2024

Send a report | Local help