SpreadJS Documentation
TextCompareType Enumeration
Specifies the text compare type.
Members
MemberDescription
BeginsWithIndicates whether the string starts with a specified string.
ContainsIndicates whether the string contains a specified string.
DoesNotBeginWithIndicates whether the string does not start with a specified string.
DoesNotContainIndicates whether the string does not contain a specified string.
DoesNotEndWithIndicates whether the string does not end with a specified string.
EndsWithIndicates whether the string ends with a specified string.
EqualsToIndicates whether the string is equal to a specified string.
NotEqualsToIndicates whether the string is not equal to a specified string.
Example
This example uses the TextCompareType enumeration.
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

See Also

Reference

GcSpread.Sheets Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.