Skip to main content

Group Management

  • 2 minutes to read

The column and row group management functionality includes creating, deleting, and resizing the groups. To make these operations available to end-users, you need to implement the respective commands in your application by using the members of the TdxSpreadSheetTableItemGroup and TdxSpreadSheetTableItemGroups classes. For more information on grouping and ungrouping the table items, refer to the following subtopics:

There are several ways of resizing the column and row groups in the Spreadsheet Control. The general method of resizing the table item groups its modifying their StartIndex and FinishIndex property values. To expand a group, you can decrease the StartIndex value and/or increase the FinishIndex value. To shrink a group, you can increase the StartIndex and/or decrease the FinishIndex property value:

Group Start and End Indexes

To achieve the same end, you can use the Add and Delete methods, available via the Table View‘s Columns.Groups and Rows.Groups properties. Note that the target group can be merged with another group on the same nesting level as a result of expansion:

Group Expansion

Refer to the Add and Delete method descriptions for additional information on alternative group resizing methods.

For more information on accessing individual table item groups, refer to the Table Item Groups Hierarchy and Accessing Individual Column or Row Groups subtopics.