PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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
SpreadsheetPosition (Function)
In French: TableurPosition
Displays the specified cell in a Spreadsheet control found in a window:
  • either the visible area of the Spreadsheet control is moved to display the cell.
  • or the cell is displayed in the top left corner of visible area of Spreadsheet control.
Example
sCell is string = SpreadsheetSeek(PSHEET_SPREEADSHEET1, "CAUTION")
// If the cell is found
IF sCell <> "" THEN
SpreadsheetPosition(PSHEET_SPREADSHEET1, sCell, psheetVisible)
END
Syntax
SpreadsheetPosition(<Spreadsheet Control> , <Cell Name> , <Type of Positioning>)
<Spreadsheet Control>: Control name
Name of Spreadsheet control to use.
<Cell Name>: Character string (with quotes)
Name of cell to use. For example: "A4".
<Type of Positioning>: Integer
Type of positioning to perform:
psheetTopLeftThe display of Spreadsheet control is modified in order for the specified cell to be positioned in the top left corner of visible control area.
psheetVisibleThe display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment