GcSpread.Sheets Namespace : TextCompareType Enumeration |
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. |
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
Object
GcSpread.Sheets.TextCompareType