Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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

Delphi
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).

You do not need to create instances of the TdxSpreadSheetConditionalFormattingRuleStyleBased class, use its descendants instead.

See Also