TdxSpreadSheetUngroupColumns Class

An action object that corresponds to the UngroupColumns command provided by the Spreadsheet and Report Designer control.

Declaration

TdxSpreadSheetUngroupColumns = class(
    TdxSpreadSheetGroupColumns
)

Remarks

The TdxSpreadSheetUngroupColumns class does not introduce any new public members. Executing this action object excludes the columns that intersect the current selection area from the column group with the highest nesting level to which it belongs. A user can execute a TdxSpreadSheetUngroupColumns action object to shrink, divide, and delete column groups.

VCL SpreadSheet: An Ungroup Columns Operation Example

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

Spreadsheet document editing is allowed (i.e., the control’s OptionsBehavior.Editing property is set to True).
The active worksheet is not protected (i.e., its Options.Protected and/or OptionsProtection.Protected properties are set to False).

To create new column groups, use a TdxSpreadSheetGroupColumns action object.