TdxSpreadSheetTableViewSelection Class

A collection of selected areas in a worksheet.

Declaration

TdxSpreadSheetTableViewSelection = class(
    TObject
)

This class implements cell selection management in the Spreadsheet and Report Designer controls.

Selected Cell Ranges

The TdxSpreadSheetTableViewSelection class has the following members that allow you to:

Move focus to a cell, column, row, or floating container (FocusedCell, FocusedColumn, FocusedContainer, FocusedRow, SetFocused).
Select specific cells or cell ranges (SelectAll, SelectCell, SelectColumns, SelectRows).
Manage the selection state (Count, Items, Add, and Clear).
Access the worksheet to which the collection belongs (View).
Obtain the rectangle that bounds all selected cell ranges and their total count (Area and Count).
Identify if the specified area matches one of the selected ranges (HasArea).
Apply batch selection state changes (BeginUpdate and EndUpdate).
Identify if a specific cell is selected (IsCellSelected).
Obtain the focused cell position (FocusedCellPosition).
Identify if a specific column or row is selected (IsColumnSelected and IsRowSelected);
Identify whether the entire column or row is selected (IsEntireColumnSelected and IsEntireRowSelected);

A worksheet’s Selection property references a TdxSpreadSheetTableViewSelection object.

TdxSpreadSheetTableViewSelection