aspose.cells

Class ColorScale

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

Property Getters/Setters Summary
functiongetIs3ColorScale()
function
           Indicates whether conditional formatting is 3 color scale.
functiongetMaxCfvo()
Get or set this ColorScale's max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
functiongetMaxColor()
function
           Get or set the gradient color for the maximum value in the range.
functiongetMidCfvo()
Get or set this ColorScale's mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.
functiongetMidColor()
function
           Get or set the gradient color for the middle value in the range.
functiongetMinCfvo()
Get or set this ColorScale's min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
functiongetMinColor()
function
           Get or set the gradient color for the minimum value in the range.
 

    • Property Getters/Setters Detail

      • getIs3ColorScale/setIs3ColorScale : boolean 

        function getIs3ColorScale() / function setIs3ColorScale(value)
        
        Indicates whether conditional formatting is 3 color scale.
      • getMinCfvo : ConditionalFormattingValue 

        function getMinCfvo()
        
        Get or set this ColorScale's min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
      • getMidCfvo : ConditionalFormattingValue 

        function getMidCfvo()
        
        Get or set this ColorScale's mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.
      • getMaxCfvo : ConditionalFormattingValue 

        function getMaxCfvo()
        
        Get or set this ColorScale's max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
      • getMinColor/setMinColor : Color 

        function getMinColor() / function setMinColor(value)
        
        Get or set the gradient color for the minimum value in the range.
      • getMidColor/setMidColor : Color 

        function getMidColor() / function setMidColor(value)
        
        Get or set the gradient color for the middle value in the range.
      • getMaxColor/setMaxColor : Color 

        function getMaxColor() / function setMaxColor(value)
        
        Get or set the gradient color for the maximum value in the range.