[]
        
(Showing Draft Content)

GC.Spread.Sheets.ConditionalFormatting.AverageConditionType

Enumeration: AverageConditionType

Sheets.ConditionalFormatting.AverageConditionType

Specifies the average condition type.

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);

Table of contents

Enumeration members

Enumeration members

above

above = 0

Specifies the above average condition.


above1StdDev

above1StdDev = 4

Specifies the above standard deviation condition.


above2StdDev

above2StdDev = 6

Specifies above the two standard deviation condition.


above3StdDev

above3StdDev = 8

Specifies above the three standard deviation condition.


below

below = 1

Specifies the below average condition.


below1StdDev

below1StdDev = 5

Specifies the below standard deviation condition.


below2StdDev

below2StdDev = 7

Specifies below the two standard deviation condition.


below3StdDev

below3StdDev = 9

Specifies below the three standard deviation condition.


equalOrAbove

equalOrAbove = 2

Specifies the above average or equal average condition.


equalOrBelow

equalOrBelow = 3

Specifies the below average or equal average condition.