AboveAverage Class

AboveAverage class

Describe the AboveAverage conditional formatting rule.This conditional formatting rule highlights cells thatare above or below the average for all values in the range.


type AboveAverage struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription
NewAboveAverageDefault constructor.

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
IsAboveAverageGet or set the flag indicating whether the rule is an “above average” rule.’true’ indicates ‘above average’.Default value is true.
SetIsAboveAverageGet or set the flag indicating whether the rule is an “above average” rule.’true’ indicates ‘above average’.Default value is true.
IsEqualAverageGet or set the flag indicating whether the ‘aboveAverage’ and ‘belowAverage’ criteriais inclusive of the average itself, or exclusive of that value.’true’ indicates to include the average value in the criteria.Default value is false.
SetIsEqualAverageGet or set the flag indicating whether the ‘aboveAverage’ and ‘belowAverage’ criteriais inclusive of the average itself, or exclusive of that value.’true’ indicates to include the average value in the criteria.Default value is false.
GetStdDevGet or set the number of standard deviations to include above or below the average in theconditional formatting rule.The input value must between 0 and 3 (include 0 and 3).Setting this value to 0 means stdDev is not set.The default value is 0.
SetStdDevGet or set the number of standard deviations to include above or below the average in theconditional formatting rule.The input value must between 0 and 3 (include 0 and 3).Setting this value to 0 means stdDev is not set.The default value is 0.