| GC.Spread.Sheets.ConditionalFormatting 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 GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.TextCompareType.contains, expected: "test"}); var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition); validator.type(GC.Spread.Sheets.DataValidation.CriteriaType.custom); activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator); spread.options.highlightInvalidData = true; activeSheet.setValue(0, 0, "testing"); //Type text in 0,0 that does not contain "test" to see invalid symbol
Object
GC.Spread.Sheets.ConditionalFormatting.TextCompareType