|
|
|
|
|
|
Category: Spreadsheet functions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|