SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / AverageConditionType Enumeration
In This Topic
    AverageConditionType Enumeration
    In This Topic
    Specifies the average condition type.
    Members
    MemberDescription
    aboveSpecifies the above average condition.
    above1StdDevSpecifies the above standard deviation condition.
    above2StdDevSpecifies above the two standard deviation condition.
    above3StdDevSpecifies above the three standard deviation condition.
    belowSpecifies the below average condition.
    below1StdDevSpecifies the below standard deviation condition.
    below2StdDevSpecifies below the two standard deviation condition.
    below3StdDevSpecifies below the three standard deviation condition.
    equalOrAboveSpecifies the above average or equal average condition.
    equalOrBelowSpecifies the below average or equal average condition.
    Example
    This example creates an average rule.
    activeSheet.setValue(0,0, 1,3);
    activeSheet.setValue(1,0, 50,3);
    activeSheet.setValue(2,0, 100,3);
    activeSheet.setValue(3,0, 2,3);
    activeSheet.setValue(4,0, 60,3);
    activeSheet.setValue(5,0, 90,3);
    activeSheet.setValue(6,0, 3,3);
    activeSheet.setValue(7,0, 40,3);
    activeSheet.setValue(8,0, 70,3);
    activeSheet.setValue(9,0, 5,3);
    activeSheet.setValue(10,0, 35,3);
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
    
    var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
    rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.averageRule);
    rule.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 3)]);
    rule.style(style);
    rule.type(GC.Spread.Sheets.ConditionalFormatting.AverageConditionType.above);
    activeSheet.conditionalFormats.addRule(rule); 
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.AverageConditionType

    See Also