ValidationCollection
Inheritance: java.lang.Object, com.aspose.cells.CollectionBase
public class ValidationCollection extends CollectionBase
Represents data validation collection.
Example
Workbook workbook = new Workbook();
ValidationCollection validations = workbook.getWorksheets().get(0).getValidations();
CellArea area = CellArea.createCellArea(0, 0, 1, 1);
Validation validation = validations.get(validations.add(area));
validation.setType(com.aspose.cells.ValidationType.LIST);
validation.setFormula1("a,b,c,d");
Methods
| Method | Description |
|---|---|
| add() | Adds a data validation to the collection. |
| add(CellArea ca) | Adds a data validation to the collection. |
| add(Object o) | Adds an item to the CollectionBase instance. |
| clear() | Removes all objects from the CollectionBase instance. |
| contains(Object o) | Return whether instance contains this object |
| equals(Object arg0) | |
| get(int index) | Gets the Validation element at the specified index. |
| getClass() | |
| getCount() | Gets the number of elements contained in the CollectionBase instance. |
| getValidationInCell(int row, int column) | Gets the validation applied to given cell. |
| hashCode() | |
| indexOf(Object o) | Determines the index of a specific item in the CollectionBase instance. |
| iterator() | Returns an enumerator that iterates through the CollectionBase instance. |
| notify() | |
| notifyAll() | |
| removeACell(int row, int column) | Removes all validation setting on the cell. |
| removeArea(CellArea ca) | Removes all validation setting on the range.. |
| removeAt(int index) | Removes the item at the specified index. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
add()
public int add()
Adds a data validation to the collection.
Remarks
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: int - Validation object index.
add(CellArea ca)
public int add(CellArea ca)
Adds a data validation to the collection.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | The area contains this validation. |
Returns: int - Validation object index.
add(Object o)
public int add(Object o)
Adds an item to the CollectionBase instance.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| o | java.lang.Object | The Object to add to the CollectionBase instance. |
Returns: int - The position into which the new element was inserted.
clear()
public void clear()
Removes all objects from the CollectionBase instance.
contains(Object o)
public boolean contains(Object o)
Return whether instance contains this object
Parameters:
| Parameter | Type | Description |
|---|---|---|
| o | java.lang.Object | test object |
Returns: boolean - Whether instance contains this object
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
get(int index)
public Validation get(int index)
Gets the Validation element at the specified index.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | int | The zero based index of the element. |
Returns: Validation - The element at the specified index.
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getCount()
public int getCount()
Gets the number of elements contained in the CollectionBase instance.
Returns: int - The number of elements contained in the CollectionBase instance.
getValidationInCell(int row, int column)
public Validation getValidationInCell(int row, int column)
Gets the validation applied to given cell.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| row | int | The row index. |
| column | int | The column index. |
Returns: Validation - Returns a Validation object or null if there is no validation for given cell
hashCode()
public native int hashCode()
Returns: int
indexOf(Object o)
public int indexOf(Object o)
Determines the index of a specific item in the CollectionBase instance.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| o | java.lang.Object | Determines the index of a specific item in the CollectionBase instance. |
Returns: int - The index of value if found in the list; otherwise, -1.
iterator()
public Iterator iterator()
Returns an enumerator that iterates through the CollectionBase instance.
Returns: java.util.Iterator - An iterator for the CollectionBase instance.
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
removeACell(int row, int column)
public void removeACell(int row, int column)
Removes all validation setting on the cell.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| row | int | The row index of the cell. |
| column | int | The column index of the cell. |
removeArea(CellArea ca)
public void removeArea(CellArea ca)
Removes all validation setting on the range..
Parameters:
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | The range which contains the validations setting. |
removeAt(int index)
public void removeAt(int index)
Removes the item at the specified index.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | int | The zero-based index of the item to remove. |
toString()
public String toString()
Returns: java.lang.String
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |