ValidationCollection
Source: aspose.
Represents data validation collection.
Methods
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) → Number
Adds a data validation to the collection.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
ca |
|
The area contains this validation. |
- Returns
-
NumberValidation object index.
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
get(index) → Validation
Gets the Validation element at the specified index.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
index |
Number |
|
The zero based index of the element. |
- Returns
-
ValidationThe element at the specified index.
get()
Reserved for internal use.
getCount()
getValidationInCell(row, column) → Validation
Gets the validation applied to given cell.
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
row |
Number |
|
The row index. |
|
column |
Number |
|
The column index. |
- Returns
-
ValidationReturns 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.
Parameters
| Name | Type | Optional | 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
| Name | Type | Optional | Description |
|---|---|---|---|
|
ca |
|
The range which contains the validations setting. |