dxSpreadSheetTypes Unit

Implements miscellaneous types used by TdxSpreadSheet and TdxSpreadSheetReportDesigner controls.

Classes

Name	Description
TdxSpreadSheetAreaList	A list of rectangles corresponding to individual cells or cell ranges.
TdxSpreadSheetCellData	Implements the cell data representation used for sorting and comparison.
TdxSpreadSheetVector	Stores a row or column vector of cell values.

Interfaces

Name	Description
IdxSpreadSheetCellData	Exposes the properties and functions that obtain cell data from ExpressSpreadSheet and ExpressQuantumGrid Views in a uniform format.
IdxSpreadSheetViewCaption
IdxSpreadSheetViewData	Exposes the methods providing access to cell data and basic layout information of worksheet and Grid Views in the ExpressSpreadSheet-compatible format.

Records

Name	Description
TdxSpreadSheetFormulaTokenDimension	Stores the size of the continuous Table View worksheet’s area used in calculations of formula expressions.
TdxSpreadSheetVectorValue	Stores a single cell value within a row or column vector.

Enums

Name	Description
TdxSpreadSheetCellDataType	Enumerates available data types for values that can be stored by cell objects.
TdxSpreadSheetCellsModification	Enumerates options that define how cell insert and delete operations affect adjacent cells.
TdxSpreadSheetCellsModificationMode	Enumerates possible changes made to a cell object.
TdxSpreadSheetClipboardCopyMode	Enumerates clipboard fill modes.
TdxSpreadSheetClipboardPasteOption	Enumerates available paste operation flags.
TdxSpreadSheetDateTimeSystem	Enumerates available date/time formats for the Spreadsheet and Report Designer controls.
TdxSpreadSheetEnterKeyNavigation	Enumerates cell navigation variants for protected worksheets using the Enter key or the Shift+Enter key combination.
TdxSpreadSheetFontScript
TdxSpreadSheetFormulaErrorCode	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.
TdxSpreadSheetFormulaOperation	Enumerates operations applied to the formula expression‘s arguments.
TdxSpreadSheetFormulaUpdateReferencesMode	Enumerates cell management operations that update references within parsed formula expressions.
TdxSpreadSheetMessageType	Enumerates types of alert messages in spreadsheet controls.
TdxSpreadSheetSizingMarker	Enumerates the sizing handles used to resize floating container objects.

Methods

Name	Description
dxSpreadSheetGetStandardColorIndex(TColor)	Returns the specified color’s index in the array of standard Excel colors.

Constants

Name	Description
dxExcelStandardColors	Stores the indexed set of colors used in Excel files (XLS, XLT, XLSX, and XLTX).
dxSpreadSheetDefaultColumnWidth	Specifies the default width (in pixels) of the Table View worksheet’s columns.
dxSpreadSheetDefaultPassword	Specifies the default password used for loading an encrypted spreadsheet document.
dxSpreadSheetDefaultPasteOptions	Specifies the default cell data pasting options.
dxSpreadSheetDefaultRowHeight	Specifies the default height (in pixels) of the Table View worksheet’s rows.
dxSpreadSheetDefaultZoomFactor	Specifies the default zoom value (as a percentage) applied to a Table View worksheet.
dxSpreadSheetFeatureFunctionPrefix	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.
dxSpreadSheetMaxCaptionLength	Specifies the maximum length of the worksheet‘s caption.
dxSpreadSheetMaxColumnCount	Specifies the maximum number of columns in a Table View worksheet.
dxSpreadSheetMaxColumnIndex	Specifies the last column‘s index within a Table View worksheet.
dxSpreadSheetMaximumZoomFactor	Specifies the upper limit (as a percentage) of the Spreadsheet control‘s zooming range.
dxSpreadSheetMaxOutlineLevel	Specifies the maximum level of the table item group hierarchy.
dxSpreadSheetMaxRowCount	Specifies the maximum number of rows within the Table View worksheet.
dxSpreadSheetMaxRowIndex	Specifies the maximum index of rows within a Table View worksheet.
dxSpreadSheetMaxSeparatorWidth	Specifies the maximum width (in pixels) of both horizontal and vertical frozen pane separators.
dxSpreadSheetMinimumZoomFactor	Specifies the lower bound (as a percentage) of the Spreadsheet control‘s zooming range.

Types

Name	Description
PFloat	A pointer to a Double (i.e., Float) variable.
PObject	A pointer type to a TObject class.
TdxSpreadSheetClipboardPasteOptions	A set of paste operation flags.
TdxSpreadSheetMessageTypes	A set of the alert message types displayed by the Spreadsheet control.
TdxSpreadSheetOperationStrings	A set of operations available for use in formula expressions.
TdxSpreadSheetReferencePath
TdxSpreadSheetSizingMarkers	A set of sizing handles displayed by a selected floating container object.
TdxSpreadSheetViewForEachCellProc	A reference to an anonymous procedure which iterates through multiple cells in a ExpressSpreadSheet or ExpressQuantumGrid View.