| |
| SpreadsheetAddData | Adds a data into a Spreadsheet control found in a window. |
| SpreadsheetAddFormula | Adds a calculation formula into a Spreadsheet control found in a window. |
| SpreadsheetAddImage | Adds an image into the current worksheet of a Spreadsheet control. |
| SpreadsheetAddName | Specifies a name to identify a cell found in a Spreadsheet control. |
| SpreadsheetAddWorksheet | Adds a worksheet into a Spreadsheet control found in a window. |
| SpreadsheetAllowProcedure | Allows the use of a WLanguage function/procedure in a formula of a Spreadsheet control. |
| SpreadsheetBorderSelection | Modifies the border of selected cells in a Spreadsheet control found in a window. |
| SpreadsheetClose | Closes the XLSX document that was opened by SpreadsheetLoad. |
| SpreadsheetControlFormula | Allows you to use a control in order to create a custom formula bar for the Spreadsheet control. |
| SpreadsheetDeleteAll | Deletes the entire data from a Spreadsheet control found in a window (cells, formulas, size and header layouts). |
| SpreadsheetDeleteColumn | Deletes a column from a Spreadsheet control. |
| SpreadsheetDeleteImage | Deletes an image from the current worksheet in a Spreadsheet control. |
| SpreadsheetDeleteName | Deletes one of the names used to identify a cell found in a Spreadsheet control. |
| SpreadsheetDeleteRow | Deletes a row from a Spreadsheet control. |
| SpreadsheetDeleteWorksheet | Deletes a worksheet from a Spreadsheet control found in a window. |
| SpreadsheetEndModification | Signals the end of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo"). |
| SpreadsheetFreeze | Used to freeze the display of a row or column in a Spreadsheet control. |
| SpreadsheetGetFormula | Retrieves the calculation formula of a cell found in a Spreadsheet control of a window. |
| SpreadsheetGetMerge | Used to find out whether a cell is merged with other cells and to get the name of merged cells. |
| SpreadsheetGetSelection | Retrieves the list of selected cells in a Spreadsheet control found in a window. |
| SpreadsheetGetSortInfo | Returns various information about the sort performed in a Spreadsheet control. |
| SpreadsheetInputFunction | Inserts a function name at cursor position in the editable cell of a Spreadsheet control found in a window. |
| SpreadsheetInsertColumn | Inserts an empty column into a Spreadsheet control found in a window. |
| SpreadsheetInsertRow | Inserts an empty row into a Spreadsheet control found in a window. |
| SpreadsheetInsertWorksheet | Inserts a worksheet into a Spreadsheet control found in a window. |
| SpreadsheetListComment | Lists all the comments on the current worksheet of a Spreadsheet control. |
| SpreadsheetListImage | Lists the images found in the current worksheet of a Spreadsheet control. |
| SpreadsheetListName | Returns the list of names that identify a cell in a Spreadsheet control. |
| SpreadsheetListWorksheet | Returns the list of worksheets found in a Spreadsheet control. |
| SpreadsheetLoad | Loads a file in XLSX format in a Spreadsheet control found in a window. |
| SpreadsheetMergeCell | Merges specified or selected cells in an Spreadsheet control. |
| SpreadsheetModifyName | Modifies the name used to identify a cell in a Spreadsheet control. |
| SpreadsheetMoveWorksheet | Moves a worksheet within a Spreadsheet control in a window. |
| SpreadsheetPosition | 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.
|
| SpreadsheetRecalculateAll | Recalculates all formulas of a Spreadsheet control found in a window (including the formulas that use WLanguage functions/procedures). |
| SpreadsheetReplace | Finds and replaces a value in a Spreadsheet control. |
| SpreadsheetRestorePositionAndSelection | 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. |
| SpreadsheetSave | Saves the content of a Spreadsheet control in a file in XLSX format. |
| SpreadsheetSavePositionAndSelection | 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.
|
| SpreadsheetSeek | Seeks a value in the cells of a Spreadsheet control found in a window. |
| SpreadsheetSelectComment | Allows you to: - know if a comment is selected in a Spreadsheet control,
- select or deselect a comment in a Spreadsheet control.
|
| SpreadsheetSelectMinus | Deselects one or more cells in a Spreadsheet control found in a window. |
| SpreadsheetSelectPlus | Selects one or more cells in a Spreadsheet control found in a window. |
| SpreadsheetSelectWorksheet | Selects a worksheet (identified by its name) in a Spreadsheet control. |
| SpreadsheetSortSelection | Sorts the values selected in a Spreadsheet control. |
| SpreadsheetStartModification | Indicates the start of a group of operations on a Spreadsheet control in a single event (management of "undo/redo"). |
| SpreadsheetStyleSelection | Returns or modifies the style of selected cells in a Spreadsheet control found in a window. |
| SpreadsheetTypeAndMaskSelection | Returns or modifies the type and mask of selected cells in a Spreadsheet control. |
| Unmerges the specified or selected cell in a Spreadsheet control. |