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

TdxSpreadSheetConditionalFormattingRuleCellIs.ComparisonOperator Property

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

#Declaration

Delphi
property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator read; write;

#Property Value

Type Description
TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator

The active cell value evaluation mode.

#Remarks

Use the ComparisonOperator property to switch between available cell evaluation modes.

cicoEqual | cicoGreaterThan | cicoLessThan | cicoGreaterThanOrEqual | cicoLessThan | cicoLessThanOrEqual | cicoNotEqual
Value Comparison Mode. The rule compares the values of all affected cells to the calculated result of a formula expression assigned to the Expression property. The Expression2 property value is ignored.
cicoBetween | cicoNotBetween
Range Comparison Mode. The rule checks if the values of all affected cells are within or outside a specific range. Expressions assigned to Expression and Expression2 properties define the value range for comparison.

Refer to the TdxSpreadSheetConditionalFormattingRuleCellIsComparisonOperator type description for detailed information on individual comparison modes.

#Default Value

The ComparisonOperator property’s default value is cicoBetween.

See Also