Unique 规则用于检单元格中的值在选中区域内是否唯一,如下图所示:
示例代码
以下代码使用了 unique 规则.
JavaScript
var style = new GC.Spread.Sheets.Style(); style.backColor = "green"; var ranges = [new GC.Spread.Sheets.Range(0, 0, 10, 1)]; activeSheet.conditionalFormats.addUniqueRule(style, ranges); activeSheet.setValue(0, 0, 50); activeSheet.setValue(1, 0, 50); activeSheet.setValue(2, 0, 11); activeSheet.setValue(3, 0, 5); // OR var style = new GC.Spread.Sheets.Style(); style.backColor = "green"; var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(); rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.UniqueRule); 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);
更多信息
addRule Method
addUniqueRule Method
NormalConditionRule class