TdxSpreadSheetConditionalFormattingRuleStyleBased Class

The base class for all classes that implement conditional formatting rules that apply custom style settings to cells for which the formatting conditions are met.

Declaration

TdxSpreadSheetConditionalFormattingRuleStyleBased = class(
    TdxSpreadSheetConditionalFormattingCustomRule,
    IdxSpreadSheetCellStyleOwner
)

Remarks

This class implements the core functionality required by the “Above or Below Average“, “Cell Is“, “Expression“, “Duplicate Values“, “Top/Bottom Values“, and “Unique Values“ conditional formatting rules.

The TdxSpreadSheetConditionalFormattingRuleStyleBased class provides the following members that allow you to:

Create or destroy a style-based conditional formatting rule at runtime (Create.
Set or modify one or more cell ranges affected by the rule (Areas).
Specify the style settings applied to the cells for which the rule’s formatting condition is met (Style).
Set the rule’s evaluation priority (Index).
Determine if the style-based rule allows other rules with lower precedence to affect the same cells if its formatting conditions is met (StopIfTrue).
Copy the rule between cells and/or cell ranges (Clone).