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(validation)
Add a Validation to the collection.
functionadd(value)
Reserved for internal use.
functionclear()
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functiongetValidationInCell(row, column)
Gets the validation applied to given cell.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremoveACell(row, column)
Removes all validation setting on the cell.
functionremoveArea(ca)
Removes all validation setting on the range..
functionremoveAt(index)
 

    • 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.
      • add

        function 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

        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.