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.StandardDeviationLevel Property

Specifies the standard deviation multiplier for the “Above or Below Average” conditional formatting rule.

#Declaration

Delphi
property StandardDeviationLevel: Integer read; write; default MinStandardDeviationLevel;

#Property Value

Type Default
Integer MinStandardDeviationLevel

#Remarks

Use this property to set the value multiplied by the standard deviation level of cell values within the cell range(s) affected by the rule. The StandardDeviationLevel property value is clamped within the range between the MinStandardDeviationLevel and MaxStandardDeviationLevel constant values, inclusive. The higher the multiplier, the fewer cells are formatted by the “Above or Below Average” conditional formatting rule:

If the ComparisonOperator property is set to abacoAboveAverageOnStandardDeviation or abacoBelowAverageOnStandardDeviation, the conditional formatting controller applies the rule’s formatting to those cells within the affected area(s) whose values are above or below the average plus or minus the product of the standard deviation and the StandardDeviationLevel property value, respectively. The controller ignores the StandardDeviationLevel property value in the case of all other "Above or Below Average" conditional formatting rule calculation modes.

The default StandardDeviationLevel property value is MinStandardDeviationLevel.

See Also