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

TdxSpreadSheetConditionalFormattingAreaInfo.StandardDeviation Property

Returns the standard deviation calculated for all numeric cell values within the list of affected cell ranges.

#Declaration

Delphi
property StandardDeviation: Double read;

#Property Value

Type
Double

#Remarks

The “Above or Below Average“ conditional formatting rule compares every numeric cell value within the affected cell ranges to the sum or difference of the AverageValue property value and a product of the StandardDeviation property value and the specified standard deviation level to identify whether to apply custom formatting to a particular cell if the rule’s ComparisonOperator property is set to abacoAboveAverageOnStandardDeviation or abacoBelowAverageOnStandardDeviation, respectively.

See Also