dxSpreadSheetCore Unit
Classes
| Name | Description |
|---|---|
| EdxSpreadSheetCannotChangePartOfArrayError | The exception class for errors that occur on an unauthorized change of an array formula result cell range. |
| EdxSpreadSheetDefinedNameError | The exception class for defined name validation errors. |
| EdxSpreadSheetFormatError | The exception class for errors related to unsupported spreadsheet document formats. |
| EdxSpreadSheetInvalidPasswordError | The exception class for password validation errors. |
| EdxSpreadSheetProtectionError | The exception class for cell modification errors that occur in protected worksheets. |
| EdxSpreadSheetReaderError | The exception class for internal data load errors. |
| TdxCustomSpreadSheet | The base class for Spreadsheet and Report Designer controls. |
| TdxSpreadSheetCell | Stores cell content and custom style settings in a worksheet. |
| TdxSpreadSheetCellViewInfo | |
| TdxSpreadSheetCellViewInfoList | |
| TdxSpreadSheetConditionalFormatting | A conditional formatting controller of a Table View worksheet displayed by the Spreadsheet or Report Designer control. |
| TdxSpreadSheetContainer | The base class for all classes that implement floating containers. |
| TdxSpreadSheetContainerAnchorPoint | A floating container object‘s anchor point. |
| TdxSpreadSheetContainers | A collection of floating containers on a single worksheet. |
| TdxSpreadSheetContainerTransform | A set of geometric transformations applied to the floating container object. |
| TdxSpreadSheetCustomCellViewInfo | |
| TdxSpreadSheetCustomDrawingObject | |
| TdxSpreadSheetCustomFiler | |
| TdxSpreadSheetCustomFormat | The base class for all classes that implement spreadsheet document file formats. |
| TdxSpreadSheetCustomHitTest | The base class for HitTest classes that store information about the Spreadsheet and Report Designer control’s visual elements located at the test point. |
| TdxSpreadSheetCustomReader | |
| TdxSpreadSheetCustomReferenceHighlighter | |
| TdxSpreadSheetCustomView | The base class for all View classes. |
| TdxSpreadSheetCustomViewOptions | The base class for all classes that implement worksheet appearance and printing settings. |
| TdxSpreadSheetCustomViewPainter | |
| TdxSpreadSheetCustomViewViewInfo | |
| TdxSpreadSheetCustomWriter | |
| TdxSpreadSheetDefaultCellStyle | Stores the style settings applied to uninitialized cells in a Table View worksheet. |
| TdxSpreadSheetDefinedName | A defined name in a spreadsheet document. |
| TdxSpreadSheetDefinedNames | A defined name collection in a spreadsheet control. |
| TdxSpreadSheetExternalLink | |
| TdxSpreadSheetExternalLinks | |
| TdxSpreadSheetFormatsRepository | A repository designed to store the spreadsheet document formats available for use in the Spreadsheet and Report Designer controls. |
| TdxSpreadSheetFormula | Stores a parsed formula expression within a cell object. |
| TdxSpreadSheetFormulaController | A spreadsheet formula expression controller. |
| TdxSpreadSheetHistory | Stores and manages the undo and redo action lists in spreadsheet controls. |
| TdxSpreadSheetHistoryAction | The base class for all classes that implement recorded history actions in an opened spreadsheet document. |
| TdxSpreadSheetHistoryAddGroupAction | |
| TdxSpreadSheetHistoryChangeConditionalFormattingAction | |
| TdxSpreadSheetHistoryCustomCommand | The base class for all classes that implement document change commands in the spreadsheet action history. |
| TdxSpreadSheetLockedStateImageOptions | Stores display settings for a spreadsheet control’s “Locked View“ image. |
| TdxSpreadSheetMergedCell | A cell created from several individual adjacent cells within a Table View worksheet. |
| TdxSpreadSheetMergedCellList | A merged cell collection in a Table View worksheet. |
| TdxSpreadSheetMergedCellsRow | |
| TdxSpreadSheetObjectList | The base class for classes that implement collections used in the ExpressSpreadSheet Suite. |
| TdxSpreadSheetObjectListItem | The base class for classes that implement collection items used in the ExpressSpreadSheet Suite. |
| TdxSpreadSheetOptionsBehavior | Stores the global behavior and functionality settings of a spreadsheet control. |
| TdxSpreadSheetOptionsMetadata | Stores spreadsheet document metadata. |
| TdxSpreadSheetOptionsView | Stores the global apperance and functionality settings of the Spreadsheet and Report Designer controls. |
| TdxSpreadSheetPageControl | A spreadsheet control’s caption bar. |
| TdxSpreadSheetPageControlHitTest | Contains a caption bar’s HitTest information. |
| TdxSpreadSheetPersistentObject | The base class for all classes that implement persistent objects, including property sets, in the ExpressSpreadSheet Suite. |
| TdxSpreadSheetRTFService | Provides access to the text formatting functionality in spreadsheet controls. |
| TdxSpreadSheetShrinkToFitCalculator | |
| TdxSpreadSheetStyles | Stores the Styles settings applied to various visual elements of the Spreadsheet and Report Designer controls. |
| TdxSpreadSheetTableColumn | A column within a column collection. |
| TdxSpreadSheetTableColumns | A column object collection within a Table View worksheet. |
| TdxSpreadSheetTableItem | The base class for individual column and row objects in a Table View worksheet. |
| TdxSpreadSheetTableItemGroup | An individual table item group created within the tree-like hierarchy. |
| TdxSpreadSheetTableItemGroups | A table item group root node within a Table View worksheet. |
| TdxSpreadSheetTableItems | The base class for table item collections within a Table View worksheet. |
| TdxSpreadSheetTableRow | A row within a row collection. |
| TdxSpreadSheetTableRows | A row object collection within the current Table View worksheet. |
| TdxSpreadSheetTableView | A worksheet type (View) designed for tabular data visualization and processing. |
| TdxSpreadSheetTableViewAbstractCellViewInfo | |
| TdxSpreadSheetTableViewCellViewInfo | |
| TdxSpreadSheetTableViewCellViewInfoList | |
| TdxSpreadSheetTableViewCustomCellViewInfo | |
| TdxSpreadSheetTableViewCustomDataCellViewInfo | |
| TdxSpreadSheetTableViewCustomGroupingAreaViewInfo | |
| TdxSpreadSheetTableViewHeaderCellViewInfo | |
| TdxSpreadSheetTableViewHitTest | Contains HitTest information of the Table View worksheet. |
| TdxSpreadSheetTableViewInfo | |
| TdxSpreadSheetTableViewMergedCellViewInfo | |
| TdxSpreadSheetTableViewMergedCellViewInfoList | |
| TdxSpreadSheetTableViewOptions | Stores general worksheet settings. |
| TdxSpreadSheetTableViewOptionsPrint | Stores all print-related settings that an individual worksheet has. |
| TdxSpreadSheetTableViewPainter | |
| TdxSpreadSheetTableViewSelection | A collection of selected areas in a worksheet. |
| TdxSpreadSheetTableViewSelectionViewInfo | |
| TdxSpreadSheetTextService | The base class for all classes that implement the text formatting functionality in spreadsheet controls. |
| TdxSpreadSheetViewAbstractCellViewInfo | |
| TdxSpreadSheetViewPersistentObject | The base class for all classes that implement worksheet View-specific persistent objects in a Spreadsheet control. |
Interfaces
Enums
| Name | Description |
|---|---|
| TdxSpreadSheetChange | Enumerates changes made in an opened spreadsheet document. |
| TdxSpreadSheetContainerAnchorType | Enumerates anchoring modes available for the floating containers. |
| TdxSpreadSheetContainerRestriction | Enumerates the restrictions that can be imposed on end-user interactions with floating container objects. |
| TdxSpreadSheetPageControlButton | Enumerates the worksheet creation and tab scroll buttons on the caption bar. |
| TdxSpreadSheetState | Enumerates specific states of the Spreadsheet and Report Designer controls. |
| TdxSpreadSheetTableItemGroupExpandButtonPosition | Enumerates available table item group expand button positions. |
| TdxSpreadSheetTableViewClearCellsOption | Enumerates operations that a cell clear operation can include. |
| TdxSpreadSheetTableViewMergedCellsConflictResolution | Enumerates the possible variants of the worksheet behavior when the cell management operation area intersects the merged cell object‘s area. |
| TdxSpreadSheetTableViewSelectionMode |
Methods
| Name | Description |
|---|---|
| dxSpreadSheetFormatsRepository | Returns the repository storing references to spreadsheet document format implementations that you can use for importing/exporting data to/from the Spreadsheet and Report Designer controls. |
Variables
| Name | Description |
|---|---|
| dxSpreadSheetTextService | Provides access to the registered cell text formatting service via a class-reference. |
Constants
| Name | Description |
|---|---|
| dxSpreadSheetBestFitWidthCorrectionPercentage | Specifies the extra width (as a percentage of the content width) added to cells with unformatted string values during best fit calculations. |
| dxSpreadSheetContainerRotateMarkerColor1 | Specifies the color of both the first and last gradient points which are used to paint the container rotation handle’s internal area. |
| dxSpreadSheetContainerRotateMarkerColor2 | Specifies the color of the intermediate gradient point which is used to paint the container rotation handle’s internal area. |
| dxSpreadSheetContainerRotateMarkerSize | Specifies the absolute diameter (in pixels) of the container rotation handle. |
| dxSpreadSheetContainerSelectionFrameColor | Specifies the color of the bounding box displayed by the selected floating container object. |
| dxSpreadSheetContainerSizingMarkerColor1 | Specifies the color of both the first and last gradient points which are used to paint the container sizing handle’s internal area. |
| dxSpreadSheetContainerSizingMarkerColor2 | Specifies the color of the intermediate gradient point which is used to paint the container sizing handle’s internal area. |
| dxSpreadSheetContainerSizingMarkerSize | Specifies both the absolute width and height (in pixels) of the container sizing handle. |
| dxSpreadSheetMovingClonedContainerAlpha | Specifies the minimum transparency level applied to the floating container object during the clone operation. |
| dxSpreadSheetMovingContainerAlpha | Specifies the minimum transparency level applied to the floating container object during the move operation. |
| dxSpreadSheetResizingContainerAlpha | Specifies the minimum transparency level applied to the floating container object during the sizing operation. |
| dxSpreadSheetRotationContainerAlpha | Specifies the minimum transparency level applied to the floating container object during the rotation operation. |
| hcBackground | |
| hcButton | |
| hcCell | |
| hcColumnHeader | |
| hcContainer | |
| hcContainerSelection | |
| hcExpandButton | |
| hcFrozenPaneSeparator | |
| hcGroup | |
| hcGroupingArea | |
| hcHyperlink | Specifies the HitTest code corresponding to a hyperlink displayed in a PDF document. |
| hcPageTab | |
| hcResizeArea | |
| hcRowHeader | |
| hcSelectionFrame | |
| hcSplitter | |
| ssvsBackground | |
| ssvsContent | |
| ssvsHeader | |
| ssvsPageControl | |
| ssvsSelection |
Types
| Name | Description |
|---|---|
| TdxSpreadSheetCellCommentHideEvent | The procedural type of a comment autohide notification event. |
| TdxSpreadSheetCellCommentShowEvent | The procedural type of a comment automatic display event. |
| TdxSpreadSheetCellStyle | |
| TdxSpreadSheetChanges | A set of changes that occurred in an opened document as a result of an operation performed in a spreadsheet control. |
| TdxSpreadSheetContainerClass | The class-reference to the base floating container class. |
| TdxSpreadSheetContainerEnumProc | A reference to an anonymous function which iterates through floating container objects. |
| TdxSpreadSheetContainerRestrictions | A set of restriction flags applied to end-user interaction with a floating container object. |
| TdxSpreadSheetCustomConditionalFormattingRule | The base class for all conditional formatting rule classes. |
| TdxSpreadSheetCustomDrawTableViewCellEvent | |
| TdxSpreadSheetCustomDrawTableViewCommonCellEvent | |
| TdxSpreadSheetCustomDrawTableViewHeaderCellEvent | |
| TdxSpreadSheetCustomFormatClass | The class-reference to a spreadsheet document format class. |
| TdxSpreadSheetCustomReaderClass | A reference to the class that implements routines designed to load data from a stream in a specific spreadsheet document format. |
| TdxSpreadSheetCustomViewClass | The class-reference to a worksheet class. |
| TdxSpreadSheetCustomWriterClass | A reference to the class that implements routines designed to save a Spreadsheet control’s content to a stream in a specific spreadsheet document format. |
| TdxSpreadSheetHistoryActionClass | A class-reference to a history action class. |
| TdxSpreadSheetHyperlinkExecuteEvent | The hyperlink activation event procedural type. |
| TdxSpreadSheetMergedCellListEnumCellsProc | A reference to an anonymous procedure which iterates through multiple merged cells. |
| TdxSpreadSheetMergedCellListEnumRowsProc | |
| TdxSpreadSheetPageControlButtons | A set of worksheet creation and tab scroll buttons. |
| TdxSpreadSheetPageControlContextPopupEvent | The procedural type of the caption bar popup menu display event. |
| TdxSpreadSheetPageControlNewTabButtonClickEvent | The procedural type of the “Add Sheet” button activation event. |
| TdxSpreadSheetPageControlTabDragAndDropEvent | The procedural type of a worksheet tab position change during a drag-and-drop operation. |
| TdxSpreadSheetPageControlTabEndDragEvent | The procedural type of a worksheet tab drop notification event. |
| TdxSpreadSheetPageControlTabStartDragEvent | The procedural type of a worksheet tab drag initiation event. |
| TdxSpreadSheetPrepareLockedStateImageEvent | The “Locked View” image draw event type used by the Spreadsheet and Report Designer controls. |
| TdxSpreadSheetProgressEvent | |
| TdxSpreadSheetScrollEvent | The type of worksheet scroll notification events that occur in the Spreadsheet and Report Designer controls. |
| TdxSpreadSheetStates | A set of Spreadsheet and Report Designer control states. |
| TdxSpreadSheetTableItemEnumProc | A reference to an anonymous procedure that iterates through multiple cell objects in a single row. |
| TdxSpreadSheetTableViewActiveCellChangingEvent | |
| TdxSpreadSheetTableViewClearCellsOptions | A set of cell clear operations. |
| TdxSpreadSheetTableViewContextPopupEvent | The procedural type of the worksheet context menu display event. |
| TdxSpreadSheetTableViewForEachCellProc | A reference to an anonymous procedure that iterates through multiple occupied cells in a worksheet and applies the same changes to all such cells. |
| TdxSpreadSheetTextServiceClass | The class-reference to a cell text formatting service. |
| TdxSpreadSheetViewCompareValuesEvent | |
| TdxSpreadSheetViewInitInplaceEditEvent | |
| TdxSpreadSheetViewInitInplaceEditValueEvent | |
| TdxSpreadSheetViewInplaceEditingEvent | |
| TdxSpreadSheetViewNotifyEvent | The worksheet event notification type. |