ColorScale

ColorScale class

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

class ColorScale;

Properties

PropertyTypeDescription
is3ColorScalebooleanIndicates whether conditional formatting is 3 color scale.
minCfvoConditionalFormattingValueReadonly. Get or set this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
midCfvoConditionalFormattingValueReadonly. Get or set this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.
maxCfvoConditionalFormattingValueReadonly. Get or set this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
minColorColorGet or set the gradient color for the minimum value in the range.
midColorColorGet or set the gradient color for the middle value in the range.
maxColorColorGet or set the gradient color for the maximum value in the range.

Methods

MethodDescription
getIs3ColorScale()@deprecated. Please use the ‘is3ColorScale’ property instead. Indicates whether conditional formatting is 3 color scale.
setIs3ColorScale(boolean)@deprecated. Please use the ‘is3ColorScale’ property instead. Indicates whether conditional formatting is 3 color scale.
getMinCfvo()@deprecated. Please use the ‘minCfvo’ property instead. Get or set this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
getMidCfvo()@deprecated. Please use the ‘midCfvo’ property instead. Get or set this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.
getMaxCfvo()@deprecated. Please use the ‘maxCfvo’ property instead. Get or set this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
getMinColor()@deprecated. Please use the ‘minColor’ property instead. Get or set the gradient color for the minimum value in the range.
setMinColor(Color)@deprecated. Please use the ‘minColor’ property instead. Get or set the gradient color for the minimum value in the range.
getMidColor()@deprecated. Please use the ‘midColor’ property instead. Get or set the gradient color for the middle value in the range.
setMidColor(Color)@deprecated. Please use the ‘midColor’ property instead. Get or set the gradient color for the middle value in the range.
getMaxColor()@deprecated. Please use the ‘maxColor’ property instead. Get or set the gradient color for the maximum value in the range.
setMaxColor(Color)@deprecated. Please use the ‘maxColor’ property instead. Get or set the gradient color for the maximum value in the range.
isNull()Checks whether the implementation object is null.

is3ColorScale

Indicates whether conditional formatting is 3 color scale.

is3ColorScale : boolean;

minCfvo

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

minCfvo : ConditionalFormattingValue;

midCfvo

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

midCfvo : ConditionalFormattingValue;

maxCfvo

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

maxCfvo : ConditionalFormattingValue;

minColor

Get or set the gradient color for the minimum value in the range.

minColor : Color;

midColor

Get or set the gradient color for the middle value in the range.

midColor : Color;

maxColor

Get or set the gradient color for the maximum value in the range.

maxColor : Color;

getIs3ColorScale()

@deprecated. Please use the ‘is3ColorScale’ property instead. Indicates whether conditional formatting is 3 color scale.

getIs3ColorScale() : boolean;

setIs3ColorScale(boolean)

@deprecated. Please use the ‘is3ColorScale’ property instead. Indicates whether conditional formatting is 3 color scale.

setIs3ColorScale(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

getMinCfvo()

@deprecated. Please use the ‘minCfvo’ property instead. Get or set this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.

getMinCfvo() : ConditionalFormattingValue;

Returns

ConditionalFormattingValue

getMidCfvo()

@deprecated. Please use the ‘midCfvo’ property instead. Get or set this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.

getMidCfvo() : ConditionalFormattingValue;

Returns

ConditionalFormattingValue

getMaxCfvo()

@deprecated. Please use the ‘maxCfvo’ property instead. Get or set this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.

getMaxCfvo() : ConditionalFormattingValue;

Returns

ConditionalFormattingValue

getMinColor()

@deprecated. Please use the ‘minColor’ property instead. Get or set the gradient color for the minimum value in the range.

getMinColor() : Color;

Returns

Color

setMinColor(Color)

@deprecated. Please use the ‘minColor’ property instead. Get or set the gradient color for the minimum value in the range.

setMinColor(value: Color) : void;

Parameters:

ParameterTypeDescription
valueColorThe value to set.

getMidColor()

@deprecated. Please use the ‘midColor’ property instead. Get or set the gradient color for the middle value in the range.

getMidColor() : Color;

Returns

Color

setMidColor(Color)

@deprecated. Please use the ‘midColor’ property instead. Get or set the gradient color for the middle value in the range.

setMidColor(value: Color) : void;

Parameters:

ParameterTypeDescription
valueColorThe value to set.

getMaxColor()

@deprecated. Please use the ‘maxColor’ property instead. Get or set the gradient color for the maximum value in the range.

getMaxColor() : Color;

Returns

Color

setMaxColor(Color)

@deprecated. Please use the ‘maxColor’ property instead. Get or set the gradient color for the maximum value in the range.

setMaxColor(value: Color) : void;

Parameters:

ParameterTypeDescription
valueColorThe value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;