TdxSpreadSheetUngroupRows Class

An action object that corresponds to the UngroupRows command provided by the Spreadsheet and Report Designer controls.

Declaration

TdxSpreadSheetUngroupRows = class(
    TdxSpreadSheetGroupColumns
)

Remarks

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

VCL SpreadSheet: An Ungroup Rows Operation Example

UI elements linked to a TdxSpreadSheetUngroupRows 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 row groups, use a TdxSpreadSheetGroupRows action object.