ValidationCollection
ValidationCollection class
Represents data validation collection.
Methods
| Name | Description |
|---|---|
| add() | Adds a data validation to the collection. NOTE: This member is now obsolete. Instead, please use ValidationCollection.Ad |
| add(ca) | Adds a data validation to the collection. |
| add() | Reserved for internal use. |
| clear() | |
| contains() | Reserved for internal use. |
| get(index) | Gets the Validation element at the specified index. |
| get() | Reserved for internal use. |
| getCount() | |
| getValidationInCell(row, column) | Gets the validation applied to given cell. |
| indexOf() | Reserved for internal use. |
| iterator() | |
| removeACell(row, column) | Removes all validation setting on the cell. |
| removeArea(ca) | Removes all validation setting on the range.. |
| removeAt() |
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.@return {Number} Validation object index.
add(ca)
Adds a data validation to the collection.
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | The area contains this validation. |
Returns: Number — Number Validation object index.
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
get(index)
Gets the Validation element at the specified index.
| Parameter | Type | Description |
|---|---|---|
| index | Number | The zero based index of the element. |
Returns: Validation — Validation The element at the specified index.
get()
Reserved for internal use.
getCount()
getValidationInCell(row, column)
Gets the validation applied to given cell.
| Parameter | Type | Description |
|---|---|---|
| row | Number | The row index. |
| column | Number | The column index. |
Returns: Validation — Validation Returns a Validation object or null if there is no validation for given cell
indexOf()
Reserved for internal use.
iterator()
removeACell(row, column)
Removes all validation setting on the cell.
| Parameter | Type | Description |
|---|---|---|
| row | Number | The row index of the cell. |
| column | Number | The column index of the cell. |
removeArea(ca)
Removes all validation setting on the range..
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | The range which contains the validations setting. |