AboveAverage Class
Contents
[
Hide
]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
Method | Description |
---|---|
NewAboveAverage | Default constructor. |
Methods
Method | Description |
---|---|
IsNull | Checks whether the implementation object is nullptr. |
IsAboveAverage | Get or set the flag indicating whether the rule is an “above average” rule.’true’ indicates ‘above average’.Default value is true. |
SetIsAboveAverage | Get or set the flag indicating whether the rule is an “above average” rule.’true’ indicates ‘above average’.Default value is true. |
IsEqualAverage | Get 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. |
SetIsEqualAverage | Get 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. |
GetStdDev | Get 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. |
SetStdDev | Get 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. |