dxSpreadSheetTypes Unit
In This Article
#Classes
Name | Description |
---|---|
Tdx |
A list of rectangles corresponding to individual cells or cell ranges. |
Tdx |
Implements the cell data representation used for sorting and comparison. |
Tdx |
Stores a row or column vector of cell values. |
#Interfaces
Name | Description |
---|---|
Idx |
Exposes the properties and functions that obtain cell data from Express |
Idx |
|
Idx |
Exposes the methods providing access to cell data and basic layout information of worksheet and Grid Views in the Express |
#Records
Name | Description |
---|---|
Tdx |
Stores the size of the continuous Table View worksheet’s area used in calculations of formula expressions. |
Tdx |
Stores a single cell value within a row or column vector. |
#Enums
Name | Description |
---|---|
Tdx |
Enumerates available data types for values that can be stored by cell objects. |
Tdx |
Enumerates options that define how cell insert and delete operations affect adjacent cells. |
Tdx |
Enumerates possible changes made to a cell object. |
Tdx |
Enumerates the possible states of cell objects within a Table View worksheet. |
Tdx |
Enumerates clipboard fill modes. |
Tdx |
Enumerates available paste operation flags. |
Tdx |
Enumerates available date/time formats for the Spreadsheet and Report Designer controls. |
Tdx |
Enumerates cell navigation variants for protected worksheets using the Enter key or the Shift+Enter key combination. |
Tdx |
|
Tdx |
Enumerates codes of all errors that can occur when the spreadsheet formula engine parses or evaluates a spreadsheet formula, conditional formatting, or calculated field expression. |
Tdx |
Enumerates operations applied to the formula expression‘s arguments. |
Tdx |
Enumerates cell management operations that update references within parsed formula expressions. |
Tdx |
Enumerates types of alert messages in spreadsheet controls. |
Tdx |
Enumerates the sizing handles used to resize floating container objects. |
#Methods
Name | Description |
---|---|
dx |
Returns the specified color’s index in the array of standard Excel colors. |
#Constants
Name | Description |
---|---|
dx |
Stores the indexed set of colors used in Excel files (XLS, XLT, XLSX, and XLTX). |
dx |
Specifies the default width (in pixels) of the Table View worksheet’s columns. |
dx |
Specifies the default password used for loading an encrypted spreadsheet document. |
dx |
Specifies the default cell data pasting options. |
dx |
Specifies the default height (in pixels) of the Table View worksheet’s rows. |
dx |
Specifies the default zoom value (as a percentage) applied to a Table View worksheet. |
dx |
Specifies a string prepended to an XLSX name token of each registered spreadsheet function signature that corresponds to a function introduced in Microsoft Excel® 2010 and later. |
dx |
Specifies the maximum length of the worksheet‘s caption. |
dx |
Specifies the maximum number of columns in a Table View worksheet. |
dx |
Specifies the last column‘s index within a Table View worksheet. |
dx |
Specifies the upper limit (as a percentage) of the Spreadsheet control‘s zooming range. |
dx |
Specifies the maximum level of the table item group hierarchy. |
dx |
Specifies the maximum number of rows within the Table View worksheet. |
dx |
Specifies the maximum index of rows within a Table View worksheet. |
dx |
Specifies the maximum width (in pixels) of both horizontal and vertical frozen pane separators. |
dx |
Specifies the lower bound (as a percentage) of the Spreadsheet control‘s zooming range. |
#Types
Name | Description |
---|---|
PFloat |
A pointer to a Double (i. |
PObject | A pointer type to a TObject class. |
Tdx |
A set of states applied to a cell object. |
Tdx |
A set of paste operation flags. |
Tdx |
A set of the alert message types displayed by the Spreadsheet control. |
Tdx |
A set of operations available for use in formula expressions. |
Tdx |
|
Tdx |
A set of sizing handles displayed by a selected floating container object. |
Tdx |
A reference to an anonymous procedure which iterates through multiple cells in a Express |