ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
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 the cell to be used. For example: "A4".
<Type of positioning>: Integer
Type of positioning to perform:
psheetTopLeftThe Spreadsheet control displays the specified cell in the upper-left corner of the control's visible area.
psheetVisibleThe specified cell is visible in the Spreadsheet control. If the specified cell is already visible, the Spreadsheet control does not change.
Component: wd290obj.dll
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/23/2024

Send a report | Local help