TdxSpreadSheet Members
A Spreadsheet control.Constructors
Name | Description |
---|---|
Create(TComponent) | Inherited from TComponent. |
CreateParented(HWND) | Inherited from TWinControl. |
Properties
Name | Description |
---|---|
Action | Inherited from TControl. |
ActiveCanvas | Provides access to the control’s GDI-based canvas. Inherited from TcxControl. |
ActiveSheet | Provides access to a generic worksheet object corresponding to the currently active sheet. Inherited from TdxCustomSpreadSheet. |
ActiveSheetAsTable | Provides access to the Table View worksheet displayed by a Spreadsheet or Report Designer. Inherited from TdxCustomSpreadSheet. |
ActiveSheetIndex | Specifies a zero-based index of the currently active worksheet. Inherited from TdxCustomSpreadSheet. |
Align | Inherited from TControl. |
AlignDisabled | Inherited from TWinControl. |
AlignWithMargins | Inherited from TControl. |
Anchors | Inherited from TControl. |
AutoSize | Inherited from TControl. |
BevelEdges | Inherited from TWinControl. |
BevelInner | Inherited from TWinControl. |
BevelKind | Inherited from TWinControl. |
BevelOuter | Inherited from TWinControl. |
BevelWidth | Inherited from TWinControl. |
BiDiMode | Specifies the control’s content bidirectional display mode. Inherited from TdxCustomSpreadSheet. |
BorderSize protected | Inherited from TcxControl. |
BorderStyle | Specifies the control’s border style. |
BorderWidth | Inherited from TWinControl. |
Bounds | Returns the control’s boundaries. Inherited from TcxControl. |
BoundsRect | Inherited from TControl. |
Brush | Inherited from TWinControl. |
Canvas | Provides access to the control’s GDI-based canvas. Inherited from TcxControl. |
Caption | Inherited from TControl. |
CellStyles | Stores all cell styles used in a workbook. Inherited from TdxCustomSpreadSheet. |
ClientBounds | Returns the control’s client area. Inherited from TcxControl. |
ClientHeight | Inherited from TControl. |
ClientOrigin | Inherited from TControl. |
ClientRect | Inherited from TControl. |
ClientWidth | Inherited from TControl. |
Color | Inherited from TControl. |
ComObject | Inherited from TComponent. |
ComponentCount | Inherited from TComponent. |
ComponentIndex | Inherited from TComponent. |
Components | Inherited from TComponent. |
ComponentState | Inherited from TComponent. |
ComponentStyle | Inherited from TComponent. |
Constraints | Inherited from TControl. |
ControlCount | Inherited from TWinControl. |
Controls | Inherited from TWinControl. |
ControlState | Inherited from TControl. |
ControlStyle | Inherited from TControl. |
Ctl3D | Inherited from TWinControl. |
CurrentPPI | Inherited from TControl. |
Cursor | Inherited from TControl. |
CustomHint | Inherited from TControl. |
DefaultCellStyle | Provides access to spreadsheet document-wide cell appearance settings. Inherited from TdxCustomSpreadSheet. |
DefinedNames | Provides access to the defined name collection within a workbook. Inherited from TdxCustomSpreadSheet. |
DesignInfo | Inherited from TComponent. |
DialogsLookAndFeel | Specifies the look and feel of all dialogs displayed by the Spreadsheet and Report Designer controls. Inherited from TdxCustomSpreadSheet. |
DockClientCount | Inherited from TWinControl. |
DockClients | Inherited from TWinControl. |
DockManager | Inherited from TWinControl. |
DockOrientation | Inherited from TControl. |
DockSite | Inherited from TWinControl. |
DoubleBuffered | Inherited from TWinControl. |
DragAndDropObject | Inherited from TcxControl. |
DragAndDropObjectClass | Inherited from TcxControl. |
DragAndDropState | Inherited from TcxControl. |
DragCursor | Inherited from TControl. |
DragKind | Inherited from TControl. |
DragMode | Inherited from TControl. |
Enabled | Inherited from TControl. |
ExplicitHeight | Inherited from TControl. |
ExplicitLeft | Inherited from TControl. |
ExplicitTop | Inherited from TControl. |
ExplicitWidth | Inherited from TControl. |
ExternalLinks | Inherited from TdxCustomSpreadSheet. |
Floating | Inherited from TControl. |
FloatingDockSiteClass | Inherited from TControl. |
FocusOnClick protected | Specifies if clicking the control focuses it. Inherited from TcxControl. |
Font | Inherited from TControl. |
FormulaController | Provides access to the formula controller. Inherited from TdxCustomSpreadSheet. |
Handle | Inherited from TWinControl. |
Height | Inherited from TControl. |
HelpContext | Inherited from TControl. |
HelpKeyword | Inherited from TControl. |
HelpType | Inherited from TControl. |
Hint | Specifies a hint message for the control. Inherited from TcxControl. |
History | Provides access to the history of undo/redo actions performed within the Spreadsheet or Report Designer control. Inherited from TdxCustomSpreadSheet. |
HostDockSite | Inherited from TControl. |
HScrollBar protected | Inherited from TcxControl. |
HScrollBarVisible protected | Inherited from TcxControl. |
ImeMode | Inherited from TWinControl. |
ImeName | Inherited from TWinControl. |
IsDesigning | Indicates if the control is currently being manipulated by the form designer. Inherited from TcxControl. |
IsDestroying | Indicates if the control is about to be destroyed. Inherited from TcxControl. |
IsDrawingLocked | Inherited from TWinControl. |
IsFocused | Identifies if the control is focused. Inherited from TcxControl. |
IsLoading | Indicates if the control is being loaded. Inherited from TcxControl. |
Keys protected | Inherited from TcxControl. |
Left | Inherited from TControl. |
LookAndFeel | Provides access to the control’s look & feel settings. Inherited from TcxControl. |
LookAndFeelPainter protected | Inherited from TcxControl. |
LRDockWidth | Inherited from TControl. |
Margins | Inherited from TControl. |
Modified | Specifies whether the control treats a loaded document as modified. Inherited from TdxCustomSpreadSheet. |
MouseCapture | Inherited from TControl. |
MouseCaptureObject | Provides access to the dragged object during a drag-and-drop operation. Inherited from TcxControl. |
MouseDownPos | Specifies the mouse pointer position when an OnMouseDown event occurs. Inherited from TcxControl. |
MouseInClient | Inherited from TWinControl. |
Name | Inherited from TComponent. |
Observers | Inherited from TComponent. |
OptionsBehavior | Specifies the global behavior and functionality settings applied to the Spreadsheet and Report Designer. Inherited from TdxCustomSpreadSheet. |
OptionsLockedStateImage | Specifies display settings for a “Locked View“ image. Inherited from TdxCustomSpreadSheet. |
OptionsMetadata | Provides access to the document’s metadata. Inherited from TdxCustomSpreadSheet. |
OptionsProtection | Specifies the spreadsheet document structure protection options. Inherited from TdxCustomSpreadSheet. |
OptionsView | Specifies the global appearance and functionality settings applied to the Spreadsheet or Report Designer control. Inherited from TdxCustomSpreadSheet. |
Owner | Inherited from TComponent. |
Padding | Inherited from TWinControl. |
PageControl | Provides access to the caption bar settings in the Spreadsheet or Report Designer controls. Inherited from TdxCustomSpreadSheet. |
Parent | Inherited from TControl. |
ParentBackground protected | Inherited from TcxControl. |
ParentBiDiMode | Inherited from TControl. |
ParentColor | Inherited from TControl. |
ParentCtl3D | Inherited from TWinControl. |
ParentCustomHint | Inherited from TControl. |
ParentDoubleBuffered | Inherited from TWinControl. |
ParentFont | Inherited from TControl. |
ParentShowHint | Inherited from TControl. |
ParentWindow | Inherited from TWinControl. |
Password | Specifies the password used to encrypt and decrypt spreadsheet documents. Inherited from TdxCustomSpreadSheet. |
PixelsPerInch | Inherited from TWinControl. |
PopupMenu | Specifies the popup menu associated with the control. Inherited from TcxControl. |
RaiseOnNonMainThreadUsage | Inherited from TControl. |
RedrawDisabled | Inherited from TWinControl. |
ScaleFactor | Inherited from TControl. |
ScrollBars protected | Inherited from TcxControl. |
SheetCount | Returns the total number of sheets within a workbook. Inherited from TdxCustomSpreadSheet. |
Sheets | Provides zero-based indexed access to individual sheets within the currently active spreadsheet document. Inherited from TdxCustomSpreadSheet. |
ShowHint | Inherited from TControl. |
Showing | Inherited from TWinControl. |
StyleElements | Inherited from TControl. |
StyleName | Inherited from TControl. |
Styles | Provides access to style settings for the visual elements of the Spreadsheet or Report Designer control. Inherited from TdxCustomSpreadSheet. |
TabOrder | Inherited from TWinControl. |
TabStop | Inherited from TcxControl. |
Tag | Inherited from TComponent. |
TBDockHeight | Inherited from TControl. |
Text | Inherited from TControl. |
TipMode | Inherited from TWinControl. |
Top | Inherited from TControl. |
Touch | Inherited from TControl. |
Transparent protected | Specifies if the control is transparent in GDI render mode. Inherited from TcxControl. |
UndockHeight | Inherited from TControl. |
UndockWidth | Inherited from TControl. |
UseDockManager | Inherited from TWinControl. |
VCLComObject | Inherited from TComponent. |
Visible | Inherited from TControl. |
VisibleDockClientCount | Inherited from TWinControl. |
VisibleSheetCount | Returns the number of non-hidden sheets within a workbook. Inherited from TdxCustomSpreadSheet. |
VisibleSheets | Provides zero-based indexed access to the list of non-hidden sheets within a workbook. Inherited from TdxCustomSpreadSheet. |
VScrollBar protected | Inherited from TcxControl. |
VScrollBarVisible protected | Inherited from TcxControl. |
Width | Inherited from TControl. |
WindowProc | Inherited from TControl. |
Methods
Events
Name | Description |
---|---|
OnActiveCellChanging | Enables you to respond to moving focus to a specific cell (making it active). Inherited from TdxCustomSpreadSheet. |
OnActiveSheetChanged | Occurs after activating another worksheet within the Spreadsheet control. Inherited from TdxCustomSpreadSheet. |
OnAlignInsertBefore | Inherited from TWinControl. |
OnAlignPosition | Inherited from TWinControl. |
OnCanResize | Inherited from TControl. |
OnClick | Inherited from TControl. |
OnCommentHide | Notifies that a comment container has been automatically hidden. Inherited from TdxCustomSpreadSheet. |
OnCommentShow | Enables you to disable automatic display for hidden comment containers. Inherited from TdxCustomSpreadSheet. |
OnCompare | Enables you to implement the custom comparator for the sorting the cell data. Inherited from TdxCustomSpreadSheet. |
OnConstrainedResize | Inherited from TControl. |
OnContextPopup | Inherited from TControl. |
OnCustomDrawTableViewCell | Enables you to implement a custom draw routine for cells within a Table View worksheet. Inherited from TdxCustomSpreadSheet. |
OnCustomDrawTableViewCommonCell | Enables you to implement a custom draw routine for helper visual elements within a Table View worksheet. Inherited from TdxCustomSpreadSheet. |
OnCustomDrawTableViewHeaderCell | Enables you to implement a custom draw routine for standard horizontal and vertical headers within a Table View worksheet. Inherited from TdxCustomSpreadSheet. |
OnDataChanged | Enables you to perform specific actions after changing a cell object‘s value. Inherited from TdxCustomSpreadSheet. |
OnDblClick | Inherited from TControl. |
OnDockDrop | Inherited from TWinControl. |
OnDockOver | Inherited from TWinControl. |
OnDragDrop | Inherited from TControl. |
OnDragOver | Inherited from TControl. |
OnEditChanged | Allows you to respond to cell editing within the current worksheet. Inherited from TdxCustomSpreadSheet. |
OnEdited | Enables you to perform specific actions after deactivation of an in-place cell editor. Inherited from TdxCustomSpreadSheet. |
OnEditing | Occurs before activation of an in-place cell editor within a worksheet. Inherited from TdxCustomSpreadSheet. |
OnEditValueChanged | Allows you to respond to cell value changes made using an in-place editor. Inherited from TdxCustomSpreadSheet. |
OnEndDock | Inherited from TControl. |
OnEndDrag | Inherited from TControl. |
OnEnter | Inherited from TWinControl. |
OnExit | Inherited from TWinControl. |
OnFocusChanged protected | Inherited from TcxControl. |
OnGesture | Inherited from TControl. |
OnGetPassword | Enables you to respond to the password request when an encrypted XLS, XLSX, XLT, or XLTX document is being loaded by the Spreadsheet or Report Designer control. Inherited from TdxCustomSpreadSheet. |
OnGetSiteInfo | Inherited from TWinControl. |
OnHistoryChanged | Enables you to respond to moving history actions between the undo and redo lists. Inherited from TdxCustomSpreadSheet. |
OnHyperlinkExecute | Allows you to perform custom actions on executing a hyperlink. Inherited from TdxCustomSpreadSheet. |
OnInitEdit | Enables you to customize the behavior of an in-place cell editor within a particular worksheet. Inherited from TdxCustomSpreadSheet. |
OnInitEditValue | Enables you to initialize the edit value of an in-place cell editor. Inherited from TdxCustomSpreadSheet. |
OnKeyDown | Inherited from TWinControl. |
OnKeyPress | Inherited from TWinControl. |
OnKeyUp | Inherited from TWinControl. |
OnLayoutChanged | Enables you to respond to the Spreadsheet or Report Designer control layout changes. Inherited from TdxCustomSpreadSheet. |
OnModifiedChanged | Enables you to track a loaded document’s modified state. Inherited from TdxCustomSpreadSheet. |
OnMouseActivate | Inherited from TControl. |
OnMouseDown | Inherited from TControl. |
OnMouseEnter | Occurs when the mouse pointer enters into the control. Inherited from TcxControl. |
OnMouseLeave | Occurs when the mouse pointer leaves the control. Inherited from TcxControl. |
OnMouseMove | Inherited from TControl. |
OnMouseUp | Inherited from TControl. |
OnMouseWheel | Inherited from TControl. |
OnMouseWheelDown | Inherited from TControl. |
OnMouseWheelUp | Inherited from TControl. |
OnPageControlContextPopup | Enables you to customize, disable, or replace the built-in popup menu invoked within the caption bar area. Inherited from TdxCustomSpreadSheet. |
OnPageControlNewTabButtonClick | Enables you to prevent the control from creating a new worksheet in response to a click on the “Add Sheet” button. Inherited from TdxCustomSpreadSheet. |
OnPageControlTabDragAndDrop | Enables you to render certain positions invalid for worksheet tab drag-and-drop operations within the caption bar. Inherited from TdxCustomSpreadSheet. |
OnPageControlTabEndDrag | Enables you to respond to a finished or cancelled drag-and-drop operation in the caption bar. Inherited from TdxCustomSpreadSheet. |
OnPageControlTabStartDrag | Enables you to respond to a drag-and-drop operation start in the caption bar. Inherited from TdxCustomSpreadSheet. |
OnPrepareLockedStateImage | Enables you to custom paint a “Locked View“ image. Inherited from TdxCustomSpreadSheet. |
OnProgress | Enables you to track the progress of time-consuming operations, such as data import/export and report building. Inherited from TdxCustomSpreadSheet. |
OnResize | Inherited from TControl. |
OnScroll | Enables you to respond to scrolling the active worksheet. Inherited from TdxCustomSpreadSheet. |
OnSelectionChanged | Enables you to respond to any changes made to the worksheet content selection. Inherited from TdxCustomSpreadSheet. |
OnStartDock | Inherited from TControl. |
OnStartDrag | Inherited from TControl. |
OnTableViewContextPopup | Enables you to customize, disable, or replace the built-in popup menu invoked in a worksheet. Inherited from TdxCustomSpreadSheet. |
OnUnDock | Inherited from TWinControl. |
See Also