aspose.cells
Class ValidationCollection

function getCount()

function get(index)

Gets the Validation element at the specified index.

Parameters:

index - The zero based index of the element.

Returns:

The element at the specified index.

function add()

Adds a data validation to the collection.

NOTE: This member is now obsolete. Instead, please use ValidationCollection.Add(CellArea) method. This property will be removed 12 months later since JANUARY 2015. Aspose apologizes for any inconvenience you may have experienced.

Returns:

Validation object index.

function add(ca)

Adds a data validation to the collection.

Parameters:

ca: CellArea - The area contains this validation.

Returns:

Validation object index.

function removeACell(row, column)

Removes all validation setting on the cell.

Parameters:

row: Number - The row index of the cell.

column: Number - The column index of the cell.

function removeArea(ca)

Removes all validation setting on the range..

Parameters:

ca: CellArea - The range which contains the validations setting.

function getValidationInCell(row, column)

Gets the validation applied to given cell.

Parameters:

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

function clear()

function removeAt(index)

function iterator()

function get(index)

Reserved for internal use.

function contains(value)

Reserved for internal use.

function add(value)

Reserved for internal use.

function indexOf(value)

Reserved for internal use.