aspose.cells

Class ConditionalFormattingValue

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

Property Getters/Setters Summary
functionisGTE()
function
setGTE(value)
           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.
functiongetType()
function
setType(value)
           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. The value of the property is FormatConditionValueType integer constant.
functiongetValue()
function
setValue(value)
           Get or set the value of this conditional formatting value object. It should be used in conjunction with Type.
 

    • Property Getters/Setters Detail

      • getValue/setValue : Object 

        function getValue() / function setValue(value)
        
        Get or set the value of this conditional formatting value object. It should be used in conjunction with Type. If the value is string and start with "=", it will be processed as a formula, otherwise we will process it as a simple value.
      • getType/setType : Number 

        function getType() / function setType(value)
        
        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. The value of the property is FormatConditionValueType integer constant.
      • isGTE/setGTE : boolean 

        function isGTE() / function setGTE(value)
        
        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.