| |
| <Spreadsheet>.AddData | Adds a data into a Spreadsheet control found in a window. |
| <Spreadsheet>.AddFormula | Adds a calculation formula into a Spreadsheet control found in a window. |
| <Spreadsheet>.AddImage | Adds an image into the current worksheet of a Spreadsheet control. |
| <Spreadsheet>.AddLink | Creates a link in a Spreadsheet control cell. The text in the cell becomes the link. |
| <Spreadsheet>.AddName | Specifies a name to identify a cell found in a Spreadsheet control. |
| <Spreadsheet>.AddWorksheet | Adds a worksheet into a Spreadsheet control found in a window. |
| <Spreadsheet>.AllowProcedure | Allows the use of a WLanguage function/procedure in a formula of a Spreadsheet control. |
| <Spreadsheet>.BorderSelection | Modifies the border of selected cells in a Spreadsheet control found in a window. |
| <Spreadsheet>.Close | Closes the XLSX document that was opened by <Spreadsheet>.Load. |
| <Spreadsheet>.ControlFormula | Allows you to use a control in order to create a custom formula bar for the Spreadsheet control. |
| <Spreadsheet>.DeleteAll | Deletes the entire data from a Spreadsheet control found in a window (cells, formulas, size and header layouts). |
| <Spreadsheet>.DeleteColumn | Deletes a column from a Spreadsheet control. |
| <Spreadsheet>.DeleteRow | Deletes a row from a Spreadsheet control. |
| <Spreadsheet>.DeleteWorksheet | Deletes a worksheet from a Spreadsheet control found in a window. |
| <Spreadsheet>.EndModification | Signals the end of grouping for a set of operations on a Spreadsheet control in a single event (management of "undo/redo"). |
| <Spreadsheet>.Freeze | Used to freeze the display of a row or column in a Spreadsheet control. |
| <Spreadsheet>.GetFormula | Retrieves the calculation formula of a cell found in a Spreadsheet control of a window. |
| <Spreadsheet>.GetMerge | Used to find out whether a cell is merged with other cells and to get the name of merged cells. |
| <Spreadsheet>.GetSelection | Retrieves the list of selected cells in a Spreadsheet control found in a window. |
| <Spreadsheet>.InsertColumn | Inserts an empty column into a Spreadsheet control found in a window. |
| <Spreadsheet>.InsertRow | Inserts an empty row into a Spreadsheet control found in a window. |
| <Spreadsheet>.InsertWorksheet | Inserts a worksheet into a Spreadsheet control found in a window. |
| <Spreadsheet>.ListComment | Lists all the comments on the current worksheet of a Spreadsheet control. |
| <Spreadsheet>.Load | Loads a file in XLSX format in a Spreadsheet control found in a window. |
| <Spreadsheet>.MergeCell | Merges specified or selected cells in a Spreadsheet control. |
| <Spreadsheet>.MoveWorksheet | Moves a worksheet within a Spreadsheet control in a window. |
| <Spreadsheet>.Position | 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.
|
| <Spreadsheet>.RecalculateAll | Recalculates all formulas of a Spreadsheet control found in a window (including the formulas that use WLanguage functions/procedures). |
| <Spreadsheet>.Replace | Finds and replaces a value in a Spreadsheet control. |
| <Spreadsheet>.RestorePositionAndSelection | 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 <Spreadsheet>.SavePositionAndSelection. |
| <Spreadsheet>.Save | Saves the content of a Spreadsheet control in a file in XLSX format. |
| <Spreadsheet>.SavePositionAndSelection | 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.
|
| <Spreadsheet>.Seek | Seeks a value in the cells of a Spreadsheet control found in a window. |
| <Spreadsheet>.SelectMinus | Deselects one or more cells in a Spreadsheet control found in a window. |
| <Spreadsheet>.SelectPlus | Selects one or more cells in a Spreadsheet control found in a window. |
| <Spreadsheet>.SelectWorksheet | Selects a worksheet (identified by its name) in a Spreadsheet control. |
| <Spreadsheet>.SortSelection | Sorts the values selected in a Spreadsheet control. |
| <Spreadsheet>.StartModification | Indicates the start of a series of actions performed in a Spreadsheet control in a single event ("undo/redo"). |
| <Spreadsheet>.StyleSelection | Returns or modifies the style of selected cells in a Spreadsheet control found in a window. |
| <Spreadsheet>.TypeAndMaskSelection | Returns or modifies the type and mask of selected cells in a Spreadsheet control. |
| <Spreadsheet>.UnmergeCell | Unmerges the specified or selected cell in a Spreadsheet control. |
| <Tableur>.SelectComment | Allows to: - know if a comment is selected in a Spreadsheet control,
- select or deselect a comment in a Spreadsheet control.
|