All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.aspose.cells.AboveAverage.html Maven / Gradle / Ivy






AboveAverage




com.aspose.cells
Class AboveAverage

java.lang.Object
    extended by 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()
voidsetAboveAverage(boolean)
           Get or set the flag indicating whether the rule is an "above average" rule. 'true' indicates 'above average'. Default value is true.
booleanisEqualAverage()
voidsetEqualAverage(boolean)
           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()
voidsetStdDev(int)
           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.

setAboveAverage

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.

setEqualAverage

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.

setStdDev

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.

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





© 2015 - 2024 Weber Informatics LLC | Privacy Policy