SpreadJS 14
GC.Spread.Sheets.ConditionalFormatting Namespace / ScaleRule class
In This Topic
    ScaleRule class
    In This Topic
    Represents a scale conditional rule.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();
    function ScaleRule;
    Example
    This example creates a rule.
    activeSheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]);
    activeSheet.setValue(0,0,1,3);
    activeSheet.setValue(1,0,45,3);
    activeSheet.setValue(2,0,75,3);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.ScaleRule

    Constructors
     NameDescription
    public ConstructorRepresents a scale conditional rule.  
    Top
    Methods
     NameDescription
    public MethodCreates a condition for the rule.  
    public MethodReturns a specified value of the rule if the cell satisfies the condition.  
    public MethodGets or sets the maximum color scale.  
    public MethodGets or sets the maximum scale type.  
    public MethodGets or sets the maximum scale value.  
    public MethodGets or sets the midpoint scale color.  
    public MethodGets or sets the midpoint scale type.  
    public MethodGets or sets the midpoint scale value.  
    public MethodGets or sets the minimum scale color.  
    public MethodGets or sets the type of minimum scale.  
    public MethodGets or sets the minimum scale value.  
    public MethodGets whether evaluation should stop if the condition evaluates to true.  
    Top
    See Also