PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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 upper-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 the Spreadsheet control to be used.
<Cell>: Character string
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 upper-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: wd280obj.dll
See also
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment