TdxSpreadSheetConditionalFormattingRuleCellIs.ComparisonOperator Property

Specifies the “Cell Is” conditional formatting rule’s cell value comparison mode.

Declaration

property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator read; write;

Property Value

Type
TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator

Remarks

Use this property to switch between available cell evaluation modes. The conditional formatting controller uses the ComparisonOperator property value to determine how to interpret the rule’s Expression and Expression2 property values. Either value can be a valid formula expression or a numeric value. The rule can accept any other value for comparison and interpret it as a text string if the ComparisonOperator property is set to cicoEqual or cicoNonEqual. Unlike all other modes, range evaluation modes (that is, cicoBetween and cicoNotBetween) use both the Expression and Expression2 property values as the range’s thresholds. Refer to the TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator type description for detailed information on available cell evaluation criteria and their limitations.

The default ComparisonOperator property value is cicoBetween.