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

TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverage.ComparisonOperator Property

Specifies the cell value comparison operator for calculating the “Above or Below Average” rule’s formatting condition.

#Declaration

Delphi
property ComparisonOperator: TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperator read; write; default abacoAboveAverage;

#Property Value

Type Default
TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperator abacoAboveAverage

#Remarks

Use this property to switch the “Above or Below Average” conditional formatting rule between available modes that determine to which cells within the affected cell range(s) the custom cell style is applied. Note that certain rule condition calculation modes also use the specified standard deviation level. Refer to the TdxSpreadSheetConditionalFormattingRuleAboveOrBelowAverageComparisonOperator type description for detailed information on all “Above or Below Average” rule’s formatting condition calculation modes.

The default ComparisonOperator property value is abacoAboveAverage.

See Also