TdxSpreadSheetConditionalFormattingRuleExpression.Expression2 Property

Specifies a value or formula expression that the “Cell Is“ conditional formatting rule uses as an additional cell formatting criterion.

Declaration

property Expression2: string index 1 read; write;

Property Value

Type	Description
string	A formula expression string.

Remarks

Only a “Cell Is” rule in the cicoBetween and cicoNotBetween comparison modes uses the Expression2 property value in addition to Expression as the criterion range’s boundaries. Refer to the TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator type description for additional information.

The Expression2 property can return an empty string if the conditional formatting provider‘s formula controller has failed to parse a previously assigned string as:

• A valid formula expression;

• A numeric value;

• Any other value that the parser can interpret as a text string (only the “Cell Is” rule’s ComparisonOperator property is set to cicoEqual or cicoNotEqual).

Note

Only the TdxSpreadSheetConditionalFormattingRuleCellIs class publishes the Expression2 property, since only “Cell Is” rules can use a value range as a formatting criterion.

The default Expression2 property value is an empty string.