TdxSpreadSheetConditionalFormattingAreaInfo.StandardDeviation Property

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

Declaration

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.