TdxSpreadSheetGroupColumns Class

An action object that implements the GroupColumns end-user command in Spreadsheet and Report Designer-based applications.

Declaration

TdxSpreadSheetGroupColumns = class(
    TdxSpreadSheetAction
)

This class does not introduce any new public members. Its overridden Execute function call groups all columns that bound the cell selection area.

VCL SpreadSheet: A Group Columns Operation Example

Consequent Execute calls for the same target columns create new groups and increase the original group’s nesting level, up to the maximum of 7.

UI elements linked to a TdxSpreadSheetGroupColumns action object are enabled only if the following conditions are met:

At least one cell is selected (the command is unavailable if a floating container is selected or the selected cell range collection is cleared).
The active worksheet is not protected (that is, its Options.Protected and/or OptionsProtection.Protected properties are set to False).

Note

To exclude columns from a group at the highest current nesting level, use the UngroupColumns command.