TdxSpreadSheetConditionalFormattingRuleExpression Class

An “Expression“ conditional formatting rule.

Declaration

TdxSpreadSheetConditionalFormattingRuleExpression = class(
    TdxSpreadSheetConditionalFormattingRuleStyleBased
)

Remarks

This rule applies custom formatting to all cells for which the parsed and calculated formula expression returns TRUE.

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

Set or modify one or more cell ranges affected by the rule (Areas);
Specify an ExpressSpreadSheet-compatible formula expression as a cell formatting criterion (Expression);
Specify the style settings applied to cells for which the rule’s criterion expression returns TRUE (Style);
Set the rule’s evaluation priority (Index);
Determine if the “Expression” rule allows other rules with lower precedence to affect the same cells for which the specified formatting condition is met (StopIfTrue);
Copy the rule between cells and/or cell ranges (Clone).

To create an “Expression” conditional formatting rule, you can:

Call a conditional formatting controller’s overloaded Add procedure (TdxSpreadSheetCustomConditionalFormatting.Add or TcxDataControllerConditionalFormatting.Add) and pass the rule’s class-reference (TdxSpreadSheetConditionalFormattingRuleExpression) as the ARuleClass parameter;
Call the Create constructor and pass the target conditional formatting controller as the AOwner parameter.

The conditional formatting controller’s Rules property provides indexed access to individual rules. To expose an “Expression” rule’s type-specific members, cast the rule to the TdxSpreadSheetConditionalFormattingRuleExpression class.