TdxSpreadSheetConditionalFormattingAreaInfo.AverageValue Property

Returns the calculated average of all numeric values within the list of affected cell ranges.

Declaration

property AverageValue: Double read;

Property Value

Type
Double

Remarks

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