SpreadJS Documentation
operator Field
The operator.
Syntax
var instance = new GcSpread.Sheets.SpecificTextRule(operator, text, style);
var value; // Type: TextComparisonOperator
value = instance.operator;
var operator : TextComparisonOperator;
Example
This example creates a rule.
var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.SpecificTextRule();
rule.style = style;
rule.text = "test";
rule.operator = GcSpread.Sheets.TextComparisonOperator.Contains;
rule.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 1)];
activeSheet.getConditionalFormats().addRule(rule);
activeSheet.setValue(0, 0, "testing");
activeSheet.setValue(1, 0, "test");
activeSheet.setValue(2, 0, "a");
activeSheet.setValue(3, 0, "t");
See Also

Reference

SpecificTextRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.