TextComparisonOperator Enumeration

Specifies the text comparison operator.

Members

Member	Description
BeginsWith	Determines whether a cell value begins with the parameter value.
Contains	Determines whether a cell value contains the parameter value.
DoesNotContain	Determines whether a cell value does not contain the parameter value.
EndsWith	Determines whether a cell value ends with the parameter value.

Example

This example creates a rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.SpecificTextRule(GcSpread.Sheets.TextComparisonOperator.Contains,"test",style);
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");

Inheritance Hierarchy

Object
GcSpread.Sheets.TextComparisonOperator

Reference

GcSpread.Sheets Namespace