Enumeration: TextCompareType

Sheets.ConditionalFormatting.TextCompareType

Specifies the text compare type.

example

//This example uses the TextCompareType enumeration.
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

Table of contents

Enumeration members

• beginsWith
• contains
• doesNotBeginWith
• doesNotContain
• doesNotEndWith
• endsWith
• equalsTo
• notEqualsTo

Enumeration members

beginsWith

• beginsWith = 2

Indicates whether the string starts with a specified string.

contains

• contains = 6

Indicates whether the string contains a specified string.

doesNotBeginWith

• doesNotBeginWith = 3

Indicates whether the string does not start with a specified string.

doesNotContain

• doesNotContain = 7

Indicates whether the string does not contain a specified string.

doesNotEndWith

• doesNotEndWith = 5

Indicates whether the string does not end with a specified string.

endsWith

• endsWith = 4

Indicates whether the string ends with a specified string.

equalsTo

• equalsTo = 0

Indicates whether the string is equal to a specified string.

notEqualsTo

• notEqualsTo = 1

Indicates whether the string is not equal to a specified string.