ValidationCollection

ValidationCollection class

Represents data validation collection.

Properties

NameTypeDescription
Countint
Item (int)ValidationGets the Validation element at the specified index.

Methods

NameDescription
addAdds a data validation to the collection.

NOTE: This member is now obsolete. Instead, please use ValidationCollection.A | | removeACell | Removes all validation setting on the cell. | | removeArea | Removes all validation setting on the range.. | | getValidationInCell | Gets the validation applied to given cell. | | clear | | | removeAt | | | iterator | | | get | Reserved for internal use. | | contains | Reserved for internal use. | | indexOf | Reserved for internal use. |

ValidationCollection.Count property

Type: int

ValidationCollection.Item (int) property

Gets the Validation element at the specified index.

Type: Validation

add() (1 of 3)

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.


add(ca) (2 of 3)

Adds a data validation to the collection.

ParameterTypeDescription
caCellAreaThe area contains this validation.

Returns: Validation object index.


add(value) (3 of 3)

Reserved for internal use.

removeACell(row, column)

Removes all validation setting on the cell.

ParameterTypeDescription
rowintThe row index of the cell.
columnintThe column index of the cell.

removeArea(ca)

Removes all validation setting on the range..

ParameterTypeDescription
caCellAreaThe range which contains the validations setting.

getValidationInCell(row, column)

Gets the validation applied to given cell.

ParameterTypeDescription
rowintThe row index.
columnintThe column index.

Returns: Returns a Validation object or null if there is no validation for given cell

clear()

removeAt(index)

iterator()

get(index)

Reserved for internal use.

contains(value)

Reserved for internal use.

indexOf(value)

Reserved for internal use.