TextCompareType Enumeration

Specifies the text compare type.

Members

Member	Description
BeginsWith	Indicates whether the string starts with a specified string.
Contains	Indicates whether the string contains a specified string.
DoesNotBeginWith	Indicates whether the string does not start with a specified string.
DoesNotContain	Indicates whether the string does not contain a specified string.
DoesNotEndWith	Indicates whether the string does not end with a specified string.
EndsWith	Indicates whether the string ends with a specified string.
EqualsTo	Indicates whether the string is equal to a specified string.
NotEqualsTo	Indicates whether the string is not equal to a specified string.

Example

This example uses the TextCompareType enumeration.

Javascript

var nCondition = new GcSpread.Sheets.TextCondition(GcSpread.Sheets.TextCompareType.Contains, "test");
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, "testing");
//Type text in 0,0 that does not contain "test" to see invalid symbol

Inheritance Hierarchy

Object
GcSpread.Sheets.TextCompareType

Reference

GcSpread.Sheets Namespace