AboveAverage
Inheritance: java.lang.Object
public 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.
Constructors
| Constructor | Description |
|---|---|
| AboveAverage() |
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getClass() | |
| getStdDev() | Gets the number of standard deviations to include above or below the average in the conditional formatting rule. |
| hashCode() | |
| isAboveAverage() | Gets the flag indicating whether the rule is an “above average” rule. |
| isEqualAverage() | Gets the flag indicating whether the ‘aboveAverage’ and ‘belowAverage’ criteria is inclusive of the average itself, or exclusive of that value. |
| notify() | |
| notifyAll() | |
| setAboveAverage(boolean value) | Sets the flag indicating whether the rule is an “above average” rule. |
| setEqualAverage(boolean value) | Sets the flag indicating whether the ‘aboveAverage’ and ‘belowAverage’ criteria is inclusive of the average itself, or exclusive of that value. |
| setStdDev(int value) | Sets the number of standard deviations to include above or below the average in the conditional formatting rule. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
AboveAverage()
public AboveAverage()
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getStdDev()
public int getStdDev()
Gets 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.
Returns: int
hashCode()
public native int hashCode()
Returns: int
isAboveAverage()
public boolean isAboveAverage()
Gets the flag indicating whether the rule is an “above average” rule. ’true’ indicates ‘above average’. Default value is true.
Returns: boolean
isEqualAverage()
public boolean isEqualAverage()
Gets 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.
Returns: boolean
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setAboveAverage(boolean value)
public void setAboveAverage(boolean value)
Sets the flag indicating whether the rule is an “above average” rule. ’true’ indicates ‘above average’. Default value is true.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setEqualAverage(boolean value)
public void setEqualAverage(boolean value)
Sets 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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setStdDev(int value)
public void setStdDev(int value)
Sets 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.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int |
toString()
public String toString()
Returns: java.lang.String
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |