com.aspose.cells

com.aspose.cells

Class AboveAverage

  • java.lang.Object
    • com.aspose.cells.AboveAverage
public class AboveAverage 
extends java.lang.Object

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
booleanisAboveAverage()
void
setAboveAverage(booleanvalue)
           Get or set the flag indicating whether the rule is an "above average" rule. 'true' indicates 'above average'. Default value is true.
booleanisEqualAverage()
void
setEqualAverage(booleanvalue)
           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.
intgetStdDev()
void
setStdDev(intvalue)
           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

        public AboveAverage()

    • Property Getters/Setters Detail

      • isAboveAverage/setAboveAverage

        public boolean isAboveAverage() / public void setAboveAverage(boolean 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

        public boolean isEqualAverage() / public void setEqualAverage(boolean 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

        public int getStdDev() / public void setStdDev(int 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.

    setAboveAverage

    public voidsetAboveAverage(booleanvalue)
    Get or set the flag indicating whether the rule is an "above average" rule. 'true' indicates 'above average'. Default value is true.

    setEqualAverage

    public voidsetEqualAverage(booleanvalue)
    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.

    setStdDev

    public voidsetStdDev(intvalue)
    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.