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

ConstructorDescription
AboveAverage()

Methods

MethodDescription
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:

ParameterTypeDescription
arg0java.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:

ParameterTypeDescription
valueboolean

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:

ParameterTypeDescription
valueboolean

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:

ParameterTypeDescription
valueint

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int