SpreadJS使用教程：如何用代码实现Average方法

SpreadJS最新试用版

Spread.Sheets 支持在单元格中设置条件格式。你可以使用样式（Styles）来设置格式化过的单元格。 条件格式中的样式是有优先级的。最后一个设置的样式的优先级最高。最先设置的样式的优先级最低。 但是如果两个样式没有冲突，（比如一个样式设置了粗体另外一个样式设置了背景颜色），两个样式均会被应用。

使用 Average 规则

示例代码
以下代码使用了 average 规则。

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);activeSheet.conditionalFormats.addAverageRule(GC.Spread.Sheets.ConditionalFormatting.AverageConditionType.Above, style, [new GC.Spread.Sheets.Range(0, 0, 10, 3)]);// ORactiveSheet.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);

如果你对我们的产品感兴趣或者有任何疑问，欢迎咨询在线客服>>