aspose.cells
Class AboveAverage

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

Constructor Summary
AboveAverage()
          
 
Property Getters/Setters Summary
functionisAboveAverage()
functionsetAboveAverage(value)
           Get or set the flag indicating whether the rule is an "above average" rule. 'true' indicates 'above average'. Default value is true.
functionisEqualAverage()
functionsetEqualAverage(value)
           Get or set the flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the average itself, or exclusive of that value. 'true' indicates to include the average value in the criteria. Default value is false.
functiongetStdDev()
functionsetStdDev(value)
           Get or set the number of standard deviations to include above or below the average in the conditional 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.
 

Constructor Detail

AboveAverage

function AboveAverage()

Property Getters/Setters Detail

isAboveAverage/setAboveAverage : boolean 

function isAboveAverage() / function setAboveAverage(value)
Get or set the flag indicating whether the rule is an "above average" rule. 'true' indicates 'above average'. Default value is true.

isEqualAverage/setEqualAverage : boolean 

function isEqualAverage() / function setEqualAverage(value)
Get or set the flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is 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/setStdDev : Number 

function getStdDev() / function setStdDev(value)
Get or set the number of standard deviations to include above or below the average in the conditional 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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.