The duplicate rule checks for duplicate values.
Using Code
This example creates a duplicate rule.
JavaScript |
Copy Code |
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="598f3f84-e88f-4a5b-9504-e78668c5157d"><ac:plain-text-body><![CDATA[ |
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); |
|
]]></ac:plain-text-body></ac:structured-macro> |
See Also
addDuplicateRule Method
addRule Method
NormalConditionRule class
RuleType Enumeration