Spread.Sheets Documentation
TextComparisonOperators Enumeration
GC.Spread.Sheets.ConditionalFormatting Namespace : TextComparisonOperators Enumeration
Specifies the text comparison operator.
Members
MemberDescription
beginsWithDetermines whether a cell value begins with the parameter value.
containsDetermines whether a cell value contains the parameter value.
doesNotContainDetermines whether a cell value does not contain the parameter value.
endsWithDetermines whether a cell value ends with the parameter value.
Example
This example creates a rule.
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
var ranges=[new GC.Spread.Sheets.Range(0,0,10,1)];
activeSheet.conditionalFormats.addSpecificTextRule(GC.Spread.Sheets.ConditionalFormatting.TextComparisonOperators.contains, "test", style, ranges);
activeSheet.setValue(0, 0, "testing");
activeSheet.setValue(1, 0, "test");
activeSheet.setValue(2, 0, "a");
activeSheet.setValue(3, 0, "t");
Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.TextComparisonOperators

See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace