TdxSpreadSheetShowConditionalFormattingRulesManager Class

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

Declaration

TdxSpreadSheetShowConditionalFormattingRulesManager = class(
    TdxSpreadSheetCustomFormatCellsAction
)

Remarks

This class does not introduce any new public members. Executing a TdxSpreadSheetShowConditionalFormattingRulesManager action object invokes the Conditional Formatting Rules Manager dialog allowing an end-user to add, modify, and remove individual conditional formatting rules in the current spreadsheet document.

VCL SpreadSheet: The Conditional Formatting Rules Manager Dialog

UI elements linked to a TdxSpreadSheetShowConditionalFormattingRulesManager 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 in-place 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).