asposecells.api
Class ValidationCollection

Represents data validation collection.

Property Getters/Setters Summary
methodgetCount()
          
methodget(index)
           Gets the Validation element at the specified index.
 
Method Summary
methodadd()
           Adds a data validation to the collection.
methodadd(ca)
           Adds a data validation to the collection.
methodadd(validation)
           Add a Validation to the collection.
methodadd(value)→ inherited from CollectionBase
          Reserved for internal use.
methodclear()→ inherited from CollectionBase
          
methodcontains(value)→ inherited from CollectionBase
          Reserved for internal use.
methodget(index)→ inherited from CollectionBase
          Reserved for internal use.
methodgetValidationInCell(row, column)
           Gets the validation applied to given cell.
methodindexOf(value)→ inherited from CollectionBase
          Reserved for internal use.
methoditerator()→ inherited from CollectionBase
          
methodremoveACell(row, column)
           Removes all validation setting on the cell.
methodremoveArea(ca)
           Removes all validation setting on the range..
methodremoveAt(index)→ inherited from CollectionBase
          
 

Property Getters/Setters Detail

getCount : int 

int getCount()

get : Validation 

Validation 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.

Method Detail

add

int 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.

add

int add(ca)
Adds a data validation to the collection.
Parameters:
ca: CellArea - The area contains this validation.
Returns:
Validation object index.

add

int add(validation)
Add a 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 October 2018. Aspose apologizes for any inconvenience you may have experienced.
Parameters:
validation: Validation - A validation object.
Returns:
Validation object index.

removeACell

 removeACell(row, column)
Removes all validation setting on the cell.
Parameters:
row: int - The row index of the cell.
column: int - The column index of the cell.

removeArea

 removeArea(ca)
Removes all validation setting on the range..
Parameters:
ca: CellArea - The range which contains the validations setting.

getValidationInCell

Validation getValidationInCell(row, column)
Gets the validation applied to given cell.
Parameters:
row: int - The row index.
column: int - The column index.
Returns:
Returns a Validation object or null if there is no validation for given cell

clear

 clear()

removeAt

 removeAt(index)

iterator

Iterator iterator()

get

Object get(index)
Reserved for internal use.

contains

boolean contains(value)
Reserved for internal use.

add

int add(value)
Reserved for internal use.

indexOf

int indexOf(value)
Reserved for internal use.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.