ColorScale

Inheritance: java.lang.Object

public class ColorScale

Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.

Methods

MethodDescription
equals(Object arg0)
getClass()
getIs3ColorScale()Indicates whether conditional formatting is 3 color scale.
getMaxCfvo()Gets this ColorScale’s max value object.
getMaxColor()Gets the gradient color for the maximum value in the range.
getMidCfvo()Gets this ColorScale’s mid value object.
getMidColor()Gets the gradient color for the middle value in the range.
getMinCfvo()Gets this ColorScale’s min value object.
getMinColor()Gets the gradient color for the minimum value in the range.
hashCode()
notify()
notifyAll()
setIs3ColorScale(boolean value)Indicates whether conditional formatting is 3 color scale.
setMaxColor(Color value)Sets the gradient color for the maximum value in the range.
setMidColor(Color value)Sets the gradient color for the middle value in the range.
setMinColor(Color value)Sets the gradient color for the minimum value in the range.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

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

getIs3ColorScale()

public boolean getIs3ColorScale()

Indicates whether conditional formatting is 3 color scale.

Returns: boolean

getMaxCfvo()

public ConditionalFormattingValue getMaxCfvo()

Gets this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.

Returns: ConditionalFormattingValue

getMaxColor()

public Color getMaxColor()

Gets the gradient color for the maximum value in the range.

Returns: Color

getMidCfvo()

public ConditionalFormattingValue getMidCfvo()

Gets this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.

Returns: ConditionalFormattingValue

getMidColor()

public Color getMidColor()

Gets the gradient color for the middle value in the range.

Returns: Color

getMinCfvo()

public ConditionalFormattingValue getMinCfvo()

Gets this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.

Returns: ConditionalFormattingValue

getMinColor()

public Color getMinColor()

Gets the gradient color for the minimum value in the range.

Returns: Color

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setIs3ColorScale(boolean value)

public void setIs3ColorScale(boolean value)

Indicates whether conditional formatting is 3 color scale.

Parameters:

ParameterTypeDescription
valueboolean

setMaxColor(Color value)

public void setMaxColor(Color value)

Sets the gradient color for the maximum value in the range.

Parameters:

ParameterTypeDescription
valueColor

setMidColor(Color value)

public void setMidColor(Color value)

Sets the gradient color for the middle value in the range.

Parameters:

ParameterTypeDescription
valueColor

setMinColor(Color value)

public void setMinColor(Color value)

Sets the gradient color for the minimum value in the range.

Parameters:

ParameterTypeDescription
valueColor

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