TdxCustomSpreadSheet.ActiveSheetAsTable Property

Provides access to the Table View worksheet displayed by a Spreadsheet or Report Designer.

Declaration

delphi

property ActiveSheetAsTable: TdxSpreadSheetTableView read;

Property Value

Type
TdxSpreadSheetTableView

Remarks

You can use the ActiveSheetAsTable property in order to perform various operations on the cell content and table structure, including but not limited to:

Scrolling the worksheet to the required position (BottomRow, LeftColumn, RightColumn, TopRow properties or the MakeFocusedCellVisible, MakeVisible, MakeVisibleColumn, and MakeVisibleRow);
Column and row management (Columns Rows properties, the DeleteColumns, DeleteRows, InsertColumns, and InsertRows);
Cell management (Cells, CreateCell, InsertCells, and DeleteCells);
Cell data sorting (SortByColumnValues and SortByRowValues);
Clipboard operations (CopyToClipboard, CutToClipboard, and PasteFromClipboard);
Appearance and functionality settings customization (Options).

For detailed information on options provided by Table View worksheets, refer to the TdxSpreadSheetTableView class description.