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	A logical cell designed to store, arrange, and process data within a Table View 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 formula expression manager employed by the Spreadsheet and Report Designer controls.
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 the Table View worksheet’s appearance and functionality 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

Name
IdxSpreadSheet
IdxSpreadSheetEditControllerListener
IdxSpreadSheetKeyboardListener
IdxSpreadSheetListener
IdxSpreadSheetListener2
IdxSpreadSheetOptionsPrintListener
IdxSpreadSheetSelectionListener
IdxSpreadSheetTableView
IdxSpreadSheetTableViewSelectionModeListener

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 classes that implement conditional formatting rules.
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.