ConditionalFormattingValue

ConditionalFormattingValue class

Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.

class ConditionalFormattingValue;

Methods

MethodDescription
getType()Get or set the type of this conditional formatting value object. Setting the type to FormatConditionValueType.Min or FormatConditionValueType.Max will auto set “Value” to null.
setType(FormatConditionValueType)Get or set the type of this conditional formatting value object. Setting the type to FormatConditionValueType.Min or FormatConditionValueType.Max will auto set “Value” to null.
isGTE()Get or set the Greater Than Or Equal flag. Use only for icon sets, determines whether this threshold value uses the greater than or equal to operator. ‘false’ indicates ‘greater than’ is used instead of ‘greater than or equal to’. Default value is true.
setIsGTE(boolean)Get or set the Greater Than Or Equal flag. Use only for icon sets, determines whether this threshold value uses the greater than or equal to operator. ‘false’ indicates ‘greater than’ is used instead of ‘greater than or equal to’. Default value is true.

getType()

Get or set the type of this conditional formatting value object. Setting the type to FormatConditionValueType.Min or FormatConditionValueType.Max will auto set “Value” to null.

getType() : FormatConditionValueType;

Returns

FormatConditionValueType

setType(FormatConditionValueType)

Get or set the type of this conditional formatting value object. Setting the type to FormatConditionValueType.Min or FormatConditionValueType.Max will auto set “Value” to null.

setType(value: FormatConditionValueType) : void;

Parameters:

ParameterTypeDescription
valueFormatConditionValueTypeThe value to set.

isGTE()

Get or set the Greater Than Or Equal flag. Use only for icon sets, determines whether this threshold value uses the greater than or equal to operator. ‘false’ indicates ‘greater than’ is used instead of ‘greater than or equal to’. Default value is true.

isGTE() : boolean;

setIsGTE(boolean)

Get or set the Greater Than Or Equal flag. Use only for icon sets, determines whether this threshold value uses the greater than or equal to operator. ‘false’ indicates ‘greater than’ is used instead of ‘greater than or equal to’. Default value is true.

setIsGTE(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.