ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
  • Special cases
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
SpreadsheetRestorePositionAndSelection (Function)
In french: TableurRestaurePositionEtSélection
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 MySave = SpreadsheetRestorePositionAndSelection(PSHEET_Spreadsheet1)
 
// Displays the B1 cell in bold
SpreadsheetSelectPlus(PSHEET_Spreadsheet, "B1")
SpreadsheetStyleSelection(PSHEET_Spreadsheet, psheetBold, True)
 
// Restores the position/selection
SpreadsheetRestorePositionAndSelection(PSHEET_Spreadsheet1, MySave)
Syntax
SpreadsheetRestorePositionAndSelection(<Spreadsheet control> [, <Save>])
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Save>: Optional character string
Save characteristics returned by 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: wd290obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help