# GC.Spread.Sheets.ConditionalFormatting.TextCompareType

## Content

# Enumeration: TextCompareType

[Sheets](../modules/GC.Spread.Sheets).[ConditionalFormatting](../modules/GC.Spread.Sheets.ConditionalFormatting).TextCompareType

Specifies the text compare type.

**`example`**
```javascript
//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](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#beginswith)
- [contains](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#contains)
- [doesNotBeginWith](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#doesnotbeginwith)
- [doesNotContain](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#doesnotcontain)
- [doesNotEndWith](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#doesnotendwith)
- [endsWith](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#endswith)
- [equalsTo](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#equalsto)
- [notEqualsTo](GC.Spread.Sheets.ConditionalFormatting.TextCompareType#notequalsto)

## Enumeration members

### <a id="beginswith" name="beginswith"></a> beginsWith

• **beginsWith** = `2`

Indicates whether the string starts with a specified string.

___

### <a id="contains" name="contains"></a> contains

• **contains** = `6`

Indicates whether the string contains a specified string.

___

### <a id="doesnotbeginwith" name="doesnotbeginwith"></a> doesNotBeginWith

• **doesNotBeginWith** = `3`

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

___

### <a id="doesnotcontain" name="doesnotcontain"></a> doesNotContain

• **doesNotContain** = `7`

Indicates whether the string does not contain a specified string.

___

### <a id="doesnotendwith" name="doesnotendwith"></a> doesNotEndWith

• **doesNotEndWith** = `5`

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

___

### <a id="endswith" name="endswith"></a> endsWith

• **endsWith** = `4`

Indicates whether the string ends with a specified string.

___

### <a id="equalsto" name="equalsto"></a> equalsTo

• **equalsTo** = `0`

Indicates whether the string is equal to a specified string.

___

### <a id="notequalsto" name="notequalsto"></a> notEqualsTo

• **notEqualsTo** = `1`

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