![]() |
||
Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate |
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.aspose.cells.AboveAverage
public class AboveAverage
Describes 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()
|
Method Summary | |
---|---|
int |
getStdDev()
Gets the number of standard deviations to include above or below the average in the conditional formatting rule. |
boolean |
isAboveAverage()
Gets the flag indicating whether the rule is an "above average" rule. |
boolean |
isEqualAverage()
Gets the flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the average itself, or exclusive of that value. |
void |
setAboveAverage(boolean b)
Sets the flag indicating whether the rule is an "above average" rule. |
void |
setEqualAverage(boolean b)
Sets the flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the average itself, or exclusive of that value. |
void |
setStdDev(int value)
Sets the number of standard deviations to include above or below the average in the conditional formatting rule. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public AboveAverage()
Method Detail |
---|
public boolean isAboveAverage()
public void setAboveAverage(boolean b)
b
- 'true' indicates 'above average'.public boolean isEqualAverage()
public void setEqualAverage(boolean b)
b
- 'true' indicates to include the average value in the criteria.public int getStdDev()
public void setStdDev(int value) throws java.lang.IllegalArgumentException
value
- must be between 0 and 3 (include 0 and 3), 0 means stdDev is not
set.
java.lang.IllegalArgumentException
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |