SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / NormalConditionRule class
In This Topic
    NormalConditionRule class
    In This Topic
    Represents a normal conditional rule.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
    function NormalConditionRule;
    Example
    activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
    var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
    cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
    cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan);
    cell.value1(5);
    cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    cell.style(style);
    activeSheet.conditionalFormats.addRule(cell);
    //button
    $("#button1").click(function () {
         cell.reset();
         activeSheet.suspendPaint();
         activeSheet.resumePaint();
    });
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule

    Constructors
     NameDescription
    public ConstructorRepresents a normal conditional rule.  
    Top
    Methods
     NameDescription
    public MethodCreates a condition for the rule.  
    public MethodGets or sets the condition formula.  
    public MethodGets or sets the comparison operator.  
    public MethodGets or sets the number of top or bottom items to apply the style to.  
    public MethodResets the rule.  
    public MethodGets or sets the text for comparison.  
    public MethodGets or sets the average condition type.  
    public MethodGets or sets the first value.  
    public MethodGets or sets the first value.  
    Top
    See Also