ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2024
Category: Spreadsheet functions
94 results
Adds a data into a Spreadsheet control found in a window.
Adds a calculation formula into a Spreadsheet control found in a window.
Adds an image into the current worksheet of a Spreadsheet control.
Creates a link in a Spreadsheet control cell. The text in the cell becomes the link.
Specifies a name to identify a cell found in a Spreadsheet control.
Adds a worksheet into a Spreadsheet control found in a window.
Allows the use of a WLanguage function/procedure in a formula of a Spreadsheet control.
Modifies the border of selected cells in a Spreadsheet control found in a window.
Closes the XLSX document that was opened by SpreadsheetLoad.
Allows you to use a control in order to create a custom formula bar for the Spreadsheet control.
Deletes the entire data from a Spreadsheet control found in a window (cells, formulas, size and header layouts).
Deletes a column from a Spreadsheet control.
Deletes a row from a Spreadsheet control.
Deletes a worksheet from a Spreadsheet control found in a window.
Signals the end of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo").
Used to freeze the display of a row or column in a Spreadsheet control.
Retrieves the calculation formula of a cell found in a Spreadsheet control of a window.
Used to find out whether a cell is merged with other cells and to get the name of merged cells.
Retrieves the list of selected cells in a Spreadsheet control found in a window.
Inserts an empty column into a Spreadsheet control found in a window.
Inserts an empty row into a Spreadsheet control found in a window.
Inserts a worksheet into a Spreadsheet control found in a window.
Loads a file in XLSX format in a Spreadsheet control found in a window.
Merges specified or selected cells in a Spreadsheet control.
Moves a worksheet within a Spreadsheet control in a window.
Displays the specified cell in a Spreadsheet control found in a window:
  • either the visible area of Spreadsheet control is moved to display the cell.
  • or the cell is displayed in the upper-left corner of visible area of Spreadsheet control.
Recalculates all formulas of a Spreadsheet control found in a window (including the formulas that use WLanguage functions/procedures).
Finds and replaces a value in a Spreadsheet control.
Restores:
  • the scrollbar position in a Spreadsheet control,
  • the current worksheet,
  • the elements selected in the current worksheet of Spreadsheet control.
These elements have been saved by SpreadsheetSavePositionAndSelection.
Saves the content of a Spreadsheet control in a file in XLSX format.
Saves:
  • the scrollbar position in a Spreadsheet control for the current worksheet,
  • the current worksheet in the Spreadsheet control,
  • the selected elements in the Spreadsheet control for the current worksheet.
Seeks a value in the cells of a Spreadsheet control found in a window.
Deselects one or more cells in a Spreadsheet control found in a window.
Selects one or more cells in a Spreadsheet control found in a window.
Selects a worksheet (identified by its name) in a Spreadsheet control.
Sorts the values selected in a Spreadsheet control.
Indicates the start of a series of actions performed in a Spreadsheet control in a single event ("undo/redo").
Returns or modifies the style of selected cells in a Spreadsheet control found in a window.
Returns or modifies the type and mask of selected cells in a Spreadsheet control.
Unmerges the specified or selected cell in a Spreadsheet control.
The psheetSelection type is used to find out the advanced characteristics of a selection in a Spreadsheet control.
The following constants are used by Spreadsheet control functions:
The following functions are used to handle the Spreadsheet control:
The following functions are used to manipulate Spreadsheet controls (prefix syntax):
Adds a data into a Spreadsheet control found in a window.
Adds a calculation formula into a Spreadsheet control found in a window.
Adds an image into the current worksheet of a Spreadsheet control.
Creates a link in a Spreadsheet control cell. The text in the cell becomes the link.
Specifies a name to identify a cell found in a Spreadsheet control.
Adds a worksheet into a Spreadsheet control found in a window.
Allows the use of a WLanguage function/procedure in a formula of a Spreadsheet control.
Modifies the border of selected cells in a Spreadsheet control found in a window.
Closes the XLSX document that was opened by SpreadsheetLoad.
Allows you to use a control in order to create a custom formula bar for the Spreadsheet control.
Deletes the entire data from a Spreadsheet control found in a window (cells, formulas, size and header layouts).
Deletes a column from a Spreadsheet control.
Deletes an image from the current worksheet in a Spreadsheet control.
Deletes one of the names used to identify a cell found in a Spreadsheet control.
Deletes a row from a Spreadsheet control.
Deletes a worksheet from a Spreadsheet control found in a window.
Signals the end of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo").
Used to freeze the display of a row or column in a Spreadsheet control.
Retrieves the calculation formula of a cell found in a Spreadsheet control of a window.
Used to find out whether a cell is merged with other cells and to get the name of merged cells.
Retrieves the list of selected cells in a Spreadsheet control found in a window.
Returns various information about the sort performed in a Spreadsheet control.
Inserts a function name at cursor position in the editable cell of a Spreadsheet control found in a window.
Inserts an empty column into a Spreadsheet control found in a window.
Inserts an empty row into a Spreadsheet control found in a window.
Inserts a worksheet into a Spreadsheet control found in a window.
Lists all the comments on the current worksheet of a Spreadsheet control.
Lists the images found in the current worksheet of a Spreadsheet control.
Returns the list of names that identify a cell in a Spreadsheet control.
Returns the list of worksheets found in a Spreadsheet control.
Loads a file in XLSX format in a Spreadsheet control found in a window.
Merges specified or selected cells in an Spreadsheet control.
Modifies the name used to identify a cell in a Spreadsheet control.
Moves a worksheet within a Spreadsheet control in a window.
Displays the specified cell in a Spreadsheet control found in a window:
  • either the visible area of Spreadsheet control is moved to display the cell.
  • or the cell is displayed in the upper-left corner of visible area of Spreadsheet control.
Recalculates all formulas of a Spreadsheet control found in a window (including the formulas that use WLanguage functions/procedures).
Finds and replaces a value in a Spreadsheet control.
Restores:
  • the scrollbar position in a Spreadsheet control,
  • the current worksheet,
  • the elements selected in the current worksheet of Spreadsheet control.
These elements have been saved by SpreadsheetSavePositionAndSelection.
Saves the content of a Spreadsheet control in a file in XLSX format.
Saves:
  • the scrollbar position in a Spreadsheet control for the current worksheet,
  • the current worksheet in the Spreadsheet control,
  • the selected elements in the Spreadsheet control for the current worksheet.
Seeks a value in the cells of a Spreadsheet control found in a window.
Allows you to:
  • know if a comment is selected in a Spreadsheet control,
  • select or deselect a comment in a Spreadsheet control.
Deselects one or more cells in a Spreadsheet control found in a window.
Selects one or more cells in a Spreadsheet control found in a window.
Selects a worksheet (identified by its name) in a Spreadsheet control.
Sorts the values selected in a Spreadsheet control.
Indicates the start of a group of operations on a Spreadsheet control in a single event (management of "undo/redo").
Returns or modifies the style of selected cells in a Spreadsheet control found in a window.
Returns or modifies the type and mask of selected cells in a Spreadsheet control.
Unmerges the specified or selected cell in a Spreadsheet control.