## Validation class

Represents data validation.settings.

```javascript
class Validation;
```


### Example
```javascript
const { Workbook, ValidationType, CellArea } = require("aspose.cells.node");

var workbook = new Workbook();
var validations = workbook.worksheets.get(0).validations;
var area = CellArea.createCellArea(0, 0, 1, 1);
var validation = validations.get(validations.add(area));
validation.type = ValidationType.List;
validation.formula1 = "a,b,c,d";
```
## Properties

| Property | Type | Description |
| --- | --- | --- |
| [operator](#operator--)| OperatorType | Represents the operator for the data validation. |
| [alertStyle](#alertStyle--)| ValidationAlertType | Represents the validation alert style. |
| [type](#type--)| ValidationType | Represents the data validation type. |
| [inputMessage](#inputMessage--)| string | Represents the data validation input message. |
| [inputTitle](#inputTitle--)| string | Represents the title of the data-validation input dialog box. |
| [errorMessage](#errorMessage--)| string | Represents the data validation error message. |
| [errorTitle](#errorTitle--)| string | Represents the title of the data-validation error dialog box. |
| [showInput](#showInput--)| boolean | Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range. |
| [showError](#showError--)| boolean | Indicates whether the data validation error message will be displayed whenever the user enters invalid data. |
| [ignoreBlank](#ignoreBlank--)| boolean | Indicates whether blank values are permitted by the range data validation. |
| [formula1](#formula1--)| string | Represents the value or expression associated with the data validation. |
| [formula2](#formula2--)| string | Represents the value or expression associated with the data validation. |
| [value1](#value1--)| Object | Represents the first value associated with the data validation. |
| [value2](#value2--)| Object | Represents the second value associated with the data validation. |
| [inCellDropDown](#inCellDropDown--)| boolean | Indicates whether data validation displays a drop-down list that contains acceptable values. |
| [areas](#areas--)| CellArea[] | Readonly. Gets all [CellArea](../cellarea/) which contain the data validation settings. |

## Methods

| Method | Description |
| --- | --- |
| [getOperator()](#getOperator--)| <b>@deprecated.</b> Please use the 'operator' property instead. Represents the operator for the data validation. |
| [setOperator(OperatorType)](#setOperator-operatortype-)| <b>@deprecated.</b> Please use the 'operator' property instead. Represents the operator for the data validation. |
| [getAlertStyle()](#getAlertStyle--)| <b>@deprecated.</b> Please use the 'alertStyle' property instead. Represents the validation alert style. |
| [setAlertStyle(ValidationAlertType)](#setAlertStyle-validationalerttype-)| <b>@deprecated.</b> Please use the 'alertStyle' property instead. Represents the validation alert style. |
| [getType()](#getType--)| <b>@deprecated.</b> Please use the 'type' property instead. Represents the data validation type. |
| [setType(ValidationType)](#setType-validationtype-)| <b>@deprecated.</b> Please use the 'type' property instead. Represents the data validation type. |
| [getInputMessage()](#getInputMessage--)| <b>@deprecated.</b> Please use the 'inputMessage' property instead. Represents the data validation input message. |
| [setInputMessage(string)](#setInputMessage-string-)| <b>@deprecated.</b> Please use the 'inputMessage' property instead. Represents the data validation input message. |
| [getInputTitle()](#getInputTitle--)| <b>@deprecated.</b> Please use the 'inputTitle' property instead. Represents the title of the data-validation input dialog box. |
| [setInputTitle(string)](#setInputTitle-string-)| <b>@deprecated.</b> Please use the 'inputTitle' property instead. Represents the title of the data-validation input dialog box. |
| [getErrorMessage()](#getErrorMessage--)| <b>@deprecated.</b> Please use the 'errorMessage' property instead. Represents the data validation error message. |
| [setErrorMessage(string)](#setErrorMessage-string-)| <b>@deprecated.</b> Please use the 'errorMessage' property instead. Represents the data validation error message. |
| [getErrorTitle()](#getErrorTitle--)| <b>@deprecated.</b> Please use the 'errorTitle' property instead. Represents the title of the data-validation error dialog box. |
| [setErrorTitle(string)](#setErrorTitle-string-)| <b>@deprecated.</b> Please use the 'errorTitle' property instead. Represents the title of the data-validation error dialog box. |
| [getShowInput()](#getShowInput--)| <b>@deprecated.</b> Please use the 'showInput' property instead. Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range. |
| [setShowInput(boolean)](#setShowInput-boolean-)| <b>@deprecated.</b> Please use the 'showInput' property instead. Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range. |
| [getShowError()](#getShowError--)| <b>@deprecated.</b> Please use the 'showError' property instead. Indicates whether the data validation error message will be displayed whenever the user enters invalid data. |
| [setShowError(boolean)](#setShowError-boolean-)| <b>@deprecated.</b> Please use the 'showError' property instead. Indicates whether the data validation error message will be displayed whenever the user enters invalid data. |
| [getIgnoreBlank()](#getIgnoreBlank--)| <b>@deprecated.</b> Please use the 'ignoreBlank' property instead. Indicates whether blank values are permitted by the range data validation. |
| [setIgnoreBlank(boolean)](#setIgnoreBlank-boolean-)| <b>@deprecated.</b> Please use the 'ignoreBlank' property instead. Indicates whether blank values are permitted by the range data validation. |
| [getFormula1()](#getFormula1--)| <b>@deprecated.</b> Please use the 'formula1' property instead. Represents the value or expression associated with the data validation. |
| [setFormula1(string)](#setFormula1-string-)| <b>@deprecated.</b> Please use the 'formula1' property instead. Represents the value or expression associated with the data validation. |
| [getFormula2()](#getFormula2--)| <b>@deprecated.</b> Please use the 'formula2' property instead. Represents the value or expression associated with the data validation. |
| [setFormula2(string)](#setFormula2-string-)| <b>@deprecated.</b> Please use the 'formula2' property instead. Represents the value or expression associated with the data validation. |
| [getValue1()](#getValue1--)| <b>@deprecated.</b> Please use the 'value1' property instead. Represents the first value associated with the data validation. |
| [setValue1(Object)](#setValue1-object-)| <b>@deprecated.</b> Please use the 'value1' property instead. Represents the first value associated with the data validation. |
| [getValue2()](#getValue2--)| <b>@deprecated.</b> Please use the 'value2' property instead. Represents the second value associated with the data validation. |
| [setValue2(Object)](#setValue2-object-)| <b>@deprecated.</b> Please use the 'value2' property instead. Represents the second value associated with the data validation. |
| [getInCellDropDown()](#getInCellDropDown--)| <b>@deprecated.</b> Please use the 'inCellDropDown' property instead. Indicates whether data validation displays a drop-down list that contains acceptable values. |
| [setInCellDropDown(boolean)](#setInCellDropDown-boolean-)| <b>@deprecated.</b> Please use the 'inCellDropDown' property instead. Indicates whether data validation displays a drop-down list that contains acceptable values. |
| [getAreas()](#getAreas--)| <b>@deprecated.</b> Please use the 'areas' property instead. Gets all [CellArea](../cellarea/) which contain the data validation settings. |
| [getFormula1(boolean, boolean)](#getFormula1-boolean-boolean-)| Gets the value or expression associated with this validation. |
| [getFormula1(boolean, boolean, number, number)](#getFormula1-boolean-boolean-number-number-)| Gets the value or expression associated with this validation for specific cell. |
| [getFormula2(boolean, boolean)](#getFormula2-boolean-boolean-)| Gets the value or expression associated with this validation. |
| [getFormula2(boolean, boolean, number, number)](#getFormula2-boolean-boolean-number-number-)| Gets the value or expression associated with this validation for specific cell. |
| [setFormula1(string, boolean, boolean)](#setFormula1-string-boolean-boolean-)| Sets the value or expression associated with this validation. |
| [setFormula2(string, boolean, boolean)](#setFormula2-string-boolean-boolean-)| Sets the value or expression associated with this validation. |
| [getListValue(number, number)](#getListValue-number-number-)| Get the value for list of the validation for the specified cell. |
| [getValue(number, number, boolean)](#getValue-number-number-boolean-)| Get the value of validation on the specific cell. |
| [addArea(CellArea)](#addArea-cellarea-)| Applies the validation to the area. |
| [addArea(CellArea, boolean, boolean)](#addArea-cellarea-boolean-boolean-)| Applies the validation to the area. |
| [addAreas(CellArea[], boolean, boolean)](#addAreas-cellareaarray-boolean-boolean-)| Applies the validation to given areas. |
| [removeArea(CellArea)](#removeArea-cellarea-)| Remove the validation settings in the range. |
| [removeAreas(CellArea[])](#removeAreas-cellareaarray-)| Removes this validation from given areas. |
| [removeACell(number, number)](#removeACell-number-number-)| Remove the validation settings in the cell. |
| [copy(Validation, CopyOptions)](#copy-validation-copyoptions-)| Copy validation. |
| [isNull()](#isNull--)| Checks whether the implementation object is null. |


### operator {#operator--}

Represents the operator for the data validation.

```javascript
operator : OperatorType;
```


### alertStyle {#alertStyle--}

Represents the validation alert style.

```javascript
alertStyle : ValidationAlertType;
```


### type {#type--}

Represents the data validation type.

```javascript
type : ValidationType;
```


### inputMessage {#inputMessage--}

Represents the data validation input message.

```javascript
inputMessage : string;
```


### inputTitle {#inputTitle--}

Represents the title of the data-validation input dialog box.

```javascript
inputTitle : string;
```


### errorMessage {#errorMessage--}

Represents the data validation error message.

```javascript
errorMessage : string;
```


### errorTitle {#errorTitle--}

Represents the title of the data-validation error dialog box.

```javascript
errorTitle : string;
```


### showInput {#showInput--}

Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.

```javascript
showInput : boolean;
```


### showError {#showError--}

Indicates whether the data validation error message will be displayed whenever the user enters invalid data.

```javascript
showError : boolean;
```


### ignoreBlank {#ignoreBlank--}

Indicates whether blank values are permitted by the range data validation.

```javascript
ignoreBlank : boolean;
```


### formula1 {#formula1--}

Represents the value or expression associated with the data validation.

```javascript
formula1 : string;
```


### formula2 {#formula2--}

Represents the value or expression associated with the data validation.

```javascript
formula2 : string;
```


### value1 {#value1--}

Represents the first value associated with the data validation.

```javascript
value1 : Object;
```


### value2 {#value2--}

Represents the second value associated with the data validation.

```javascript
value2 : Object;
```


### inCellDropDown {#inCellDropDown--}

Indicates whether data validation displays a drop-down list that contains acceptable values.

```javascript
inCellDropDown : boolean;
```


### areas {#areas--}

Readonly. Gets all [CellArea](../cellarea/) which contain the data validation settings.

```javascript
areas : CellArea[];
```


### getOperator() {#getOperator--}

<b>@deprecated.</b> Please use the 'operator' property instead. Represents the operator for the data validation.

```javascript
getOperator() : OperatorType;
```


**Returns**

[OperatorType](../operatortype/)

### setOperator(OperatorType) {#setOperator-operatortype-}

<b>@deprecated.</b> Please use the 'operator' property instead. Represents the operator for the data validation.

```javascript
setOperator(value: OperatorType) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | [OperatorType](../operatortype/) | The value to set. |

### getAlertStyle() {#getAlertStyle--}

<b>@deprecated.</b> Please use the 'alertStyle' property instead. Represents the validation alert style.

```javascript
getAlertStyle() : ValidationAlertType;
```


**Returns**

[ValidationAlertType](../validationalerttype/)

### setAlertStyle(ValidationAlertType) {#setAlertStyle-validationalerttype-}

<b>@deprecated.</b> Please use the 'alertStyle' property instead. Represents the validation alert style.

```javascript
setAlertStyle(value: ValidationAlertType) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | [ValidationAlertType](../validationalerttype/) | The value to set. |

### getType() {#getType--}

<b>@deprecated.</b> Please use the 'type' property instead. Represents the data validation type.

```javascript
getType() : ValidationType;
```


**Returns**

[ValidationType](../validationtype/)

### setType(ValidationType) {#setType-validationtype-}

<b>@deprecated.</b> Please use the 'type' property instead. Represents the data validation type.

```javascript
setType(value: ValidationType) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | [ValidationType](../validationtype/) | The value to set. |

### getInputMessage() {#getInputMessage--}

<b>@deprecated.</b> Please use the 'inputMessage' property instead. Represents the data validation input message.

```javascript
getInputMessage() : string;
```


### setInputMessage(string) {#setInputMessage-string-}

<b>@deprecated.</b> Please use the 'inputMessage' property instead. Represents the data validation input message.

```javascript
setInputMessage(value: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | string | The value to set. |

### getInputTitle() {#getInputTitle--}

<b>@deprecated.</b> Please use the 'inputTitle' property instead. Represents the title of the data-validation input dialog box.

```javascript
getInputTitle() : string;
```


### setInputTitle(string) {#setInputTitle-string-}

<b>@deprecated.</b> Please use the 'inputTitle' property instead. Represents the title of the data-validation input dialog box.

```javascript
setInputTitle(value: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | string | The value to set. |

### getErrorMessage() {#getErrorMessage--}

<b>@deprecated.</b> Please use the 'errorMessage' property instead. Represents the data validation error message.

```javascript
getErrorMessage() : string;
```


### setErrorMessage(string) {#setErrorMessage-string-}

<b>@deprecated.</b> Please use the 'errorMessage' property instead. Represents the data validation error message.

```javascript
setErrorMessage(value: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | string | The value to set. |

### getErrorTitle() {#getErrorTitle--}

<b>@deprecated.</b> Please use the 'errorTitle' property instead. Represents the title of the data-validation error dialog box.

```javascript
getErrorTitle() : string;
```


### setErrorTitle(string) {#setErrorTitle-string-}

<b>@deprecated.</b> Please use the 'errorTitle' property instead. Represents the title of the data-validation error dialog box.

```javascript
setErrorTitle(value: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | string | The value to set. |

### getShowInput() {#getShowInput--}

<b>@deprecated.</b> Please use the 'showInput' property instead. Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.

```javascript
getShowInput() : boolean;
```


### setShowInput(boolean) {#setShowInput-boolean-}

<b>@deprecated.</b> Please use the 'showInput' property instead. Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.

```javascript
setShowInput(value: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | boolean | The value to set. |

### getShowError() {#getShowError--}

<b>@deprecated.</b> Please use the 'showError' property instead. Indicates whether the data validation error message will be displayed whenever the user enters invalid data.

```javascript
getShowError() : boolean;
```


### setShowError(boolean) {#setShowError-boolean-}

<b>@deprecated.</b> Please use the 'showError' property instead. Indicates whether the data validation error message will be displayed whenever the user enters invalid data.

```javascript
setShowError(value: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | boolean | The value to set. |

### getIgnoreBlank() {#getIgnoreBlank--}

<b>@deprecated.</b> Please use the 'ignoreBlank' property instead. Indicates whether blank values are permitted by the range data validation.

```javascript
getIgnoreBlank() : boolean;
```


### setIgnoreBlank(boolean) {#setIgnoreBlank-boolean-}

<b>@deprecated.</b> Please use the 'ignoreBlank' property instead. Indicates whether blank values are permitted by the range data validation.

```javascript
setIgnoreBlank(value: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | boolean | The value to set. |

### getFormula1() {#getFormula1--}

<b>@deprecated.</b> Please use the 'formula1' property instead. Represents the value or expression associated with the data validation.

```javascript
getFormula1() : string;
```


### setFormula1(string) {#setFormula1-string-}

<b>@deprecated.</b> Please use the 'formula1' property instead. Represents the value or expression associated with the data validation.

```javascript
setFormula1(value: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | string | The value to set. |

### getFormula2() {#getFormula2--}

<b>@deprecated.</b> Please use the 'formula2' property instead. Represents the value or expression associated with the data validation.

```javascript
getFormula2() : string;
```


### setFormula2(string) {#setFormula2-string-}

<b>@deprecated.</b> Please use the 'formula2' property instead. Represents the value or expression associated with the data validation.

```javascript
setFormula2(value: string) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | string | The value to set. |

### getValue1() {#getValue1--}

<b>@deprecated.</b> Please use the 'value1' property instead. Represents the first value associated with the data validation.

```javascript
getValue1() : Object;
```


### setValue1(Object) {#setValue1-object-}

<b>@deprecated.</b> Please use the 'value1' property instead. Represents the first value associated with the data validation.

```javascript
setValue1(value: Object) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | Object | The value to set. |

### getValue2() {#getValue2--}

<b>@deprecated.</b> Please use the 'value2' property instead. Represents the second value associated with the data validation.

```javascript
getValue2() : Object;
```


### setValue2(Object) {#setValue2-object-}

<b>@deprecated.</b> Please use the 'value2' property instead. Represents the second value associated with the data validation.

```javascript
setValue2(value: Object) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | Object | The value to set. |

### getInCellDropDown() {#getInCellDropDown--}

<b>@deprecated.</b> Please use the 'inCellDropDown' property instead. Indicates whether data validation displays a drop-down list that contains acceptable values.

```javascript
getInCellDropDown() : boolean;
```


### setInCellDropDown(boolean) {#setInCellDropDown-boolean-}

<b>@deprecated.</b> Please use the 'inCellDropDown' property instead. Indicates whether data validation displays a drop-down list that contains acceptable values.

```javascript
setInCellDropDown(value: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | boolean | The value to set. |

### getAreas() {#getAreas--}

<b>@deprecated.</b> Please use the 'areas' property instead. Gets all [CellArea](../cellarea/) which contain the data validation settings.

```javascript
getAreas() : CellArea[];
```


**Returns**

[CellArea](../cellarea/)[]

### getFormula1(boolean, boolean) {#getFormula1-boolean-boolean-}

Gets the value or expression associated with this validation.

```javascript
getFormula1(isR1C1: boolean, isLocal: boolean) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |

**Returns**

The value or expression associated with this validation.

### getFormula1(boolean, boolean, number, number) {#getFormula1-boolean-boolean-number-number-}

Gets the value or expression associated with this validation for specific cell.

```javascript
getFormula1(isR1C1: boolean, isLocal: boolean, row: number, column: number) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
| row | number | The row index. |
| column | number | The column index. |

**Returns**

The value or expression associated with this validation.

### getFormula2(boolean, boolean) {#getFormula2-boolean-boolean-}

Gets the value or expression associated with this validation.

```javascript
getFormula2(isR1C1: boolean, isLocal: boolean) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |

**Returns**

The value or expression associated with this validation.

### getFormula2(boolean, boolean, number, number) {#getFormula2-boolean-boolean-number-number-}

Gets the value or expression associated with this validation for specific cell.

```javascript
getFormula2(isR1C1: boolean, isLocal: boolean, row: number, column: number) : string;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
| row | number | The row index. |
| column | number | The column index. |

**Returns**

The value or expression associated with this validation.

### setFormula1(string, boolean, boolean) {#setFormula1-string-boolean-boolean-}

Sets the value or expression associated with this validation.

```javascript
setFormula1(formula: string, isR1C1: boolean, isLocal: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| formula | string | The value or expression associated with this format condition. |
| isR1C1 | boolean | Whether the formula is R1C1 formula. |
| isLocal | boolean | Whether the formula is locale formatted. |

### setFormula2(string, boolean, boolean) {#setFormula2-string-boolean-boolean-}

Sets the value or expression associated with this validation.

```javascript
setFormula2(formula: string, isR1C1: boolean, isLocal: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| formula | string | The value or expression associated with this format condition. |
| isR1C1 | boolean | Whether the formula is R1C1 formula. |
| isLocal | boolean | Whether the formula is locale formatted. |

### getListValue(number, number) {#getListValue-number-number-}

Get the value for list of the validation for the specified cell.

```javascript
getListValue(row: number, column: number) : Object;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| row | number | The row index. |
| column | number | The column index. |

**Returns**

The value to produce the list of this validation for the specified cell. If the list references to a range, then the returned value will be a [ReferredArea](../referredarea/) object; Otherwise the returned value may be null, object[], or simple object.

**Remarks**

Only for validation whose type is List and has been applied to given cell, otherwise null will be returned.

### getValue(number, number, boolean) {#getValue-number-number-boolean-}

Get the value of validation on the specific cell.

```javascript
getValue(row: number, column: number, isValue1: boolean) : Object;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| row | number | The row index. |
| column | number | The column index. |
| isValue1 | boolean | Indicates whether getting the first value. |

### addArea(CellArea) {#addArea-cellarea-}

Applies the validation to the area.

```javascript
addArea(cellArea: CellArea) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| cellArea | [CellArea](../cellarea/) | The area. |

**Remarks**

It is equivalent to use [AddArea(Aspose.Cells.CellArea,bool,bool)](../addarea(aspose.cells.cellarea,bool,bool)/) with checking intersection and edge.

### addArea(CellArea, boolean, boolean) {#addArea-cellarea-boolean-boolean-}

Applies the validation to the area.

```javascript
addArea(cellArea: CellArea, checkIntersection: boolean, checkEdge: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| cellArea | [CellArea](../cellarea/) | The area. |
| checkIntersection | boolean | Whether check the intersection of given area with existing validations' areas.         /// If one validation has been applied in given area(or part of it),         /// then the existing validation should be removed at first from given area.         /// Otherwise corruption may be caused for the generated Validations.         /// If user is sure that the added area does not intersect with any existing area,         /// this parameter can be set as false for performance consideration. |
| checkEdge | boolean | Whether check the edge of this validation's applied areas.         /// Validation's internal settings depend on the top-left one of its applied ranges,         /// so if given area will become the new top-left one of the applied ranges,         /// the internal settings should be changed and rebuilt, otherwise unexpected result may be caused.         /// If user is sure that the added area is not the top-left one,         /// this parameter can be set as false for performance consideration. |

**Remarks**

In this method, we will remove all old validations in given area. For the top-left one of Validation's applied ranges, firstly its StartRow is smallest, secondly its StartColumn is the smallest one of those areas who have the same smallest StartRow.

### addAreas(CellArea[], boolean, boolean) {#addAreas-cellareaarray-boolean-boolean-}

Applies the validation to given areas.

```javascript
addAreas(areas: CellArea[], checkIntersection: boolean, checkEdge: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| areas | [CellArea](../cellarea/)[] | The areas. |
| checkIntersection | boolean | Whether check the intersection of given area with existing validations' areas.         /// If one validation has been applied in given area(or part of it),         /// then the existing validation should be removed at first from given area.         /// Otherwise corruption may be caused for the generated Validations.         /// If user is sure that all the added areas do not intersect with any existing area,         /// this parameter can be set as false for performance consideration. |
| checkEdge | boolean | Whether check the edge of this validation's applied areas.         /// Validation's internal settings depend on the top-left one of its applied ranges,         /// so if one of given areas will become the new top-left one of the applied ranges,         /// the internal settings should be changed and rebuilt, otherwise unexpected result may be caused.         /// If user is sure that no one of those added areas is the top-left,         /// this parameter can be set as false for performance consideration. |

**Remarks**

In this method, we will remove all old validations in given area. For the top-left one of Validation's applied ranges, firstly its StartRow is smallest, secondly its StartColumn is the smallest one of those areas who have the same smallest StartRow.

### removeArea(CellArea) {#removeArea-cellarea-}

Remove the validation settings in the range.

```javascript
removeArea(cellArea: CellArea) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| cellArea | [CellArea](../cellarea/) | the areas where this validation settings should be removed. |

### removeAreas(CellArea[]) {#removeAreas-cellareaarray-}

Removes this validation from given areas.

```javascript
removeAreas(areas: CellArea[]) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| areas | [CellArea](../cellarea/)[] | the areas where this validation settings should be removed. |

### removeACell(number, number) {#removeACell-number-number-}

Remove the validation settings in the cell.

```javascript
removeACell(row: number, column: number) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| row | number | The row index. |
| column | number | The column index. |

### copy(Validation, CopyOptions) {#copy-validation-copyoptions-}

Copy validation.

```javascript
copy(source: Validation, copyOption: CopyOptions) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| source | [Validation](../validation/) | The source validation. |
| copyOption | [CopyOptions](../copyoptions/) | The copy option. |

### isNull() {#isNull--}

Checks whether the implementation object is null.

```javascript
isNull() : boolean;
```