ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
  • Special cases
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Restores:
  • the scrollbar position in a Spreadsheet control,
  • the current worksheet,
  • the elements selected in the current worksheet of Spreadsheet control.
These elements have been saved by SpreadsheetSavePositionAndSelection.
Example
let MaSauvegarde = SpreadsheetSavePositionAndSelection(TBLR_Tableur1) 

// Met en gras la cellule B1
SpreadsheetSelectPlus(TBLR_Tableur, "B1")
SpreadsheetStyleSelection(TBLR_Tableur, psheetBold, True)

// Restaure la position/sélection 
SpreadsheetRestorePositionAndSelection(TBLR_Tableur1, MaSauvegarde)
Syntax
SpreadsheetRestorePositionAndSelection(<Spreadsheet control> [, <Save>])
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Save>: Optional character string
Backup characteristics returned by function SpreadsheetSavePositionAndSelection.
  • If this parameter is not specified, the last backup performed by SpreadsheetSavePositionAndSelection on the control is used (if it exists).
  • An error occurs if no backup was performed or if the specified string is invalid.
Remarks

Special cases

  • The name of the control used for the save (SpreadsheetSavePositionAndSelection) can differ from the name used for the restore operation. This feature can be useful to duplicate the position and the selection on two Spreadsheet controls displayed alternatively for example.
  • SpreadsheetRestorePositionAndSelection has no effect if the control is empty.
Component: wd300obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help