TdxSpreadSheetClearFormats Class

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

Declaration

TdxSpreadSheetClearFormats = class(
    TdxSpreadSheetCustomFormatCellsAction
)

Remarks

This class does not introduce any new public members. Executing this action object restores the default style settings for all currently selected cells.

UI elements linked to a TdxSpreadSheetClearFormats 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).
Cell formatting is allowed in the active worksheet (i.e., its OptionsProtection.ActualAllowFormatCells property returns True).

If no cells can be selected in the protected worksheet (i.e., its OptionsProtection.ActualAllowSelectUnlockedCells property returns False), executing the TdxSpreadSheetClearFormats action object has no effect.

Note

To remove both the cell values and custom styles from the current cell selections, use the TdxSpreadSheetClearAll action object.