ValidationCollection

ValidationCollection class

Represents data validation collection.

class ValidationCollection;

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.
getCount()	@deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in.
isNull()	Checks whether the implementation object is null.

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.

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.

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.

Removes all validation setting on the range..

removeArea(ca: CellArea) : void;

Parameters:

Parameter	Type	Description
ca	CellArea	The range which contains the validations setting.

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

@deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in.

getCount() : number;

Checks whether the implementation object is null.

isNull() : boolean;