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 ConstructorNormalConditionRule ConstructorRepresents a normal conditional rule.  
    Top
    Methods
     NameDescription
    public MethodcreateConditionCreates a condition for the rule.  
    public MethodformulaGets or sets the condition formula.  
    public MethodoperatorGets or sets the comparison operator.  
    public MethodrankGets or sets the number of top or bottom items to apply the style to.  
    public MethodresetResets the rule.  
    public MethodtextGets or sets the text for comparison.  
    public MethodtypeGets or sets the average condition type.  
    public Methodvalue1Gets or sets the first value.  
    public Methodvalue2Gets or sets the first value.  
    Top
    See Also

    Reference

    GC.Spread.Sheets.ConditionalFormatting Namespace
    Conditional Formatting

     

     

    Copyright © 2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page