SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / NormalConditionRule class / type Method
The average condition type.
In This Topic
    type Method
    In This Topic
    Gets or sets the average condition type.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(ruleType, ranges, style, operator, value1, value2, text, formula, type, rank);
    var returnValue; // Type: any
    returnValue = instance.type(value);
    function type( 
       value : AverageConditionType
    ) : any;

    Parameters

    value
    The average condition type.

    Return Value

    If no value is set, returns the average condition type; otherwise, returns the number condition rule.
    Example
    The following examples create rules.
    activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    style.foreColor = "black";
    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)]);
    cell.style(style);
    activeSheet.conditionalFormats.addRule(cell);
    
    var style1 = new GC.Spread.Sheets.Style();
    style1.foreColor = "red";
    var top = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
    top.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.top10Rule);
    top.type(GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType.top);
    top.rank(3);
    top.style(style1);
    top.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
    top.stopIfTrue(true);
    activeSheet.conditionalFormats.addRule(top);
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(GC.Spread.Sheets.ConditionalFormatting.RuleType.dateOccurringRule, [new GC.Spread.Sheets.Range(0,0,10,1)], style, null, null, null, null, null, GC.Spread.Sheets.ConditionalFormatting.DateOccurringType.nextWeek);
    activeSheet.conditionalFormats.addRule(rule);
    var d = new Date();
    activeSheet.setValue(0, 0, d);
    activeSheet.setValue(1, 0, new Date(d.setDate(d.getDate()+1)));
    activeSheet.setValue(2, 0, new Date(d.setDate(d.getDate()+5)));
    activeSheet.setValue(3, 0,new Date(d.setDate(d.getDate()+6)));
    activeSheet.setValue(4, 0,new Date(d.setDate(d.getDate()+7)));
    activeSheet.setValue(5, 0, new Date(d.setDate(d.getDate()+8)));
    See Also