ValidationCollection
Contents
[
Hide
]ValidationCollection class
Represents data validation collection.
class ValidationCollection;
Methods
| Method | Description |
|---|---|
| get(number) | Gets the Validation element at the specified index. |
| add(CellArea) | Adds a data validation to the collection. |
| removeACell(number, number) | Removes all validation setting on the cell. |
| removeArea(CellArea) | Removes all validation setting on the range.. |
| getValidationInCell(number, number) | Gets the validation applied to given cell. |
get(number)
Gets the Validation element at the specified index.
get(index: number) : Validation;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number | The zero based index of the element. |
Returns
The element at the specified index.
add(CellArea)
Adds a data validation to the collection.
add(ca: CellArea) : number;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | The area contains this validation. |
Returns
Validation object index.
removeACell(number, number)
Removes all validation setting on the cell.
removeACell(row: number, column: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| row | number | The row index of the cell. |
| column | number | The column index of the cell. |
removeArea(CellArea)
Removes all validation setting on the range..
removeArea(ca: CellArea) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | The range which contains the validations setting. |
getValidationInCell(number, number)
Gets the validation applied to given cell.
getValidationInCell(row: number, column: number) : Validation;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| row | number | The row index. |
| column | number | The column index. |
Returns
Returns a Validation object or null if there is no validation for given cell