PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

This page concerns the 23 + version of WINDEV. Upgrade your version.
  • 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 position of scrollbar 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 Name> [, <Backup>])
<Spreadsheet Name>: Character string (with or without quotes)
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
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment