PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
New WINDEV 23 feature!
  • Special cases
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
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 MyBackup = 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, MyBackup)
Syntax
SpreadsheetRestorePositionAndSelection(<Spreadsheet Control> [, <Backup>])
<Spreadsheet Control>: Control name
Name of Spreadsheet control to use.
<Backup>: Optional character string
Backup 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 control name used for the backup (SpreadsheetSavePositionAndSelection) can differ from the name used for the restore. 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.
Components
WINDEVReports and Queries wd230obj.dll
See also
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment