TdxSpreadSheetInsertRows Class

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

Declaration

TdxSpreadSheetInsertRows = class(
    TdxSpreadSheetCustomEditAction
)

Remarks

This class does not introduce any new public members. Executing this action object inserts rows intersecting the current cell selection area. The number of inserted rows matches the absolute height (in cells) of the current selection.

VCL SpreadSheet: An Insert Rows Operation Example

UI elements linked to a TdxSpreadSheetInsertRows 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).
An in-place cell editor is inactive (the active worksheet‘s IsEditing property returns False).
The row insert operation is allowed in the active worksheet (i.e., its OptionsProtection.ActualAllowInsertRows property returns True).

Note

If the active Table View worksheet contains more than one selected cell range, a TdxSpreadSheetInsertColumns action object raises the EdxSpreadSheetError exception.