PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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> , <Type of positioning>)
<Spreadsheet control>: Control name
Name of Spreadsheet control to use.
<Cell>: 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.
Component : wd250obj.dll
See also
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment