TdxSpreadSheetClearAll Class

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

Declaration

TdxSpreadSheetClearAll = class(
    TdxSpreadSheetCustomEditCellsAction
)

Remarks

This class does not introduce any new public members. Executing this action object removes the values from all currenly selected cells and restores their default style settings. Technically, a TdxSpreadSheetClearAll action object calls the Clear procedure for every cell object located within the currently selected cell ranges.

UI elements linked to a TdxSpreadSheetClearAll 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 active worksheet is not protected (i.e., its OptionsProtection.Protected property is set to False) or the current selection area contains no locked cells.