aspose.cells
Class ValidationCollection

Represents data validation collection.

Property Getters/Setters Summary
functiongetCount()
          
functionget(index)
           Gets the Validation element at the specified index.
 
Method Summary
functionadd()
           Adds a data validation to the collection.
functionadd(ca)
           Adds a data validation to the collection.
functionadd(value)→ inherited from CollectionBase
          Reserved for internal use.
functionclear()→ inherited from CollectionBase
          
functioncontains(value)→ inherited from CollectionBase
          Reserved for internal use.
functionget(index)→ inherited from CollectionBase
          Reserved for internal use.
functiongetValidationInCell(row, column)
           Gets the validation applied to given cell.
functionindexOf(value)→ inherited from CollectionBase
          Reserved for internal use.
functioniterator()→ inherited from CollectionBase
          
functionremoveACell(row, column)
           Removes all validation setting on the cell.
functionremoveArea(ca)
           Removes all validation setting on the range..
functionremoveAt(index)→ inherited from CollectionBase
          
 

Property Getters/Setters Detail

getCount : Number 

function getCount()

get : Validation 

function 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

function 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

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

removeACell

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

removeArea

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

getValidationInCell

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

clear

function clear()

removeAt

function removeAt(index)

iterator

function iterator()

get

function get(index)
Reserved for internal use.

contains

function contains(value)
Reserved for internal use.

add

function add(value)
Reserved for internal use.

indexOf

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