Unique 规则用于检单元格中的值在选中区域内是否唯一,如下图所示:
示例代码
以下代码使用了 unique 规则.
JavaScript | Copy Code | ||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="7e478573-5e51-4e62-9177-85bde523e051"><ac:plain-text-body><![CDATA[ | 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);// ORvar 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); |
| ]]></ac:plain-text-body></ac:structured-macro> |
另见
addRule Method
addUniqueRule Method
NormalConditionRule class