PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

This page concerns the 23 + version of WINDEV. Upgrade your version.
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
SpreadsheetSavePositionAndSelection (Function)
In French: TableurSauvePositionEtSélection
Saves:
  • the position of scrollbar in a Spreadsheet control for the current worksheet,
  • the current worksheet in the Spreadsheet control,
  • the elements selected in the Spreadsheet control for the current worksheet.
These elements can be restored by SpreadsheetRestorePositionAndSelection.
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
<Result> = SpreadsheetSavePositionAndSelection(<Spreadsheet>)
<Result>: Character string
<Spreadsheet>: Character string (with or without quotes)
Name of Spreadsheet control to use.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment