TdxSpreadSheetConditionalFormattingAreaInfo.StandardDeviation Property
In This Article
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