Skip to main content

TdxSpreadSheetTableItemGroups Class

A table item group root node within a Table View worksheet.

Declaration

TdxSpreadSheetTableItemGroups = class(
    TObject
)

Remarks

This class implements the data grouping functionality in the Spreadsheet control, which allows you to organize a large amount of data into separate collapsible groups of columns and rows. A TdxSpreadSheetTableItemGroups object is the container for all table item groups created within a Table View worksheet.

The TdxSpreadSheetTableItemGroups class extends its ancestor with members allowing you to:

  • Improve the performance of a spreadsheet-based application in the case of multiple operations on column or row groups (BeginUpdate and EndUpdate);

  • Identify the number of non-nested table item groups within the hierarchy (Count);

  • Create or expand a table item group in the hierarchy (Add);

  • Change orientations of all group outline brackets displayed by the current node (ExpandButtonPosition);

  • Shrink, divide, or delete table item groups with the highest nesting level (Delete);

  • Delete all previously created table item groups within the hierarchy (DeleteAll);

  • Expand or collapse all table item groups within the hierarchy to the specified nesting level (ExpandToLevel);

  • Access table item groups at the root level (i.e., parent or non-nested groups) within the hierarchy of groups (Items).

The TdxSpreadSheetTableItemGroups object is referenced by the column and row collection Groups property.

Refer to the Cell Data Grouping topic for additional information on the data grouping functionality.

Inheritance

TObject
TdxSpreadSheetTableItemGroups
See Also