TdxCustomSpreadSheet.ActiveSheetAsTable Property

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

Declaration

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.