SpreadJS 条件格式教程：Duplicate 和 Date Occurring 规则的应用

SpreadJS最新试用版

使用 Date Occurring 规则

Date Occurring 规则是用来比对日期的。以下代码使用了 Date Occurring 规则。

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)));// ORvar style = new GC.Spread.Sheets.Style();style.backColor = "red";activeSheet.conditionalFormats.addDateOccurringRule(GC.Spread.Sheets.ConditionalFormatting.DateOccurringType.NextWeek, style, [new GC.Spread.Sheets.Range(0,0,10,1)]);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)));

使用 Duplicate 规则

Duplicate 规则用于检查单元格中重复的值。

示例代码

以下代码使用了 duplicate 规则。

var style = new GC.Spread.Sheets.Style();style.backColor = "yellow";var ranges=[new GC.Spread.Sheets.Range(0,0,10,1)];activeSheet.conditionalFormats.addDuplicateRule(style, ranges);activeSheet.setValue(0, 0, 50);activeSheet.setValue(1, 0, 50);activeSheet.setValue(2, 0, 11);activeSheet.setValue(3, 0, 5);// ORvar style = new GC.Spread.Sheets.Style();style.backColor = "yellow";var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.DuplicateRule);rule.ranges([new GC.Spread.Sheets.Range(0,0,10,1)]);rule.style(style);activeSheet.conditionalFormats.addRule(rule);activeSheet.setValue(0, 0, 50);activeSheet.setValue(1, 0, 50);activeSheet.setValue(2, 0, 11);activeSheet.setValue(3, 0, 5);

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