枚举: AverageConditionType

Sheets.ConditionalFormatting.AverageConditionType

平均值条件格式

代码示例

//本示例创建一个平均值条件格式
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

枚举值成员

• above
• above1StdDev
• above2StdDev
• above3StdDev
• below
• below1StdDev
• below2StdDev
• below3StdDev
• equalOrAbove
• equalOrBelow

枚举值成员

above

• above = 0

高于平均值条件

above1StdDev

• above1StdDev = 4

标准偏差高于1条件

above2StdDev

• above2StdDev = 6

标准偏差高于2条件

above3StdDev

• above3StdDev = 8

标准偏差高于3条件

below

• below = 1

低于平均值条件

below1StdDev

• below1StdDev = 5

标准偏差低于1条件

below2StdDev

• below2StdDev = 7

标准偏差低于2条件

below3StdDev

• below3StdDev = 9

标准偏差低于3条件

equalOrAbove

• equalOrAbove = 2

等于或高于平均值条件

equalOrBelow

• equalOrBelow = 3

等于或低于平均值条件