aspose.cells

aspose.cells

Class ErrorCheckOption

Error check setting applied on certain ranges.

Method Summary
functionaddRange(ca)
Adds one influenced range by this setting.
functiongetCountOfRange()
Gets the count of ranges that influenced by this setting.
functiongetRange(index)
Gets the influenced range of this setting by given index.
functionisErrorCheck(errorCheckType)
Checks whether given error type will be checked.
functionremoveRange(index)
Removes one range by given index.
functionsetErrorCheck(errorCheckType, isCheck)
Sets whether given error type will be checked.
 

    • Method Detail

      • isErrorCheck

        function isErrorCheck(errorCheckType)
        Checks whether given error type will be checked.
        Parameters:
        errorCheckType: Number - A ErrorCheckType value. error type can be checked
        Returns:
        return true if given error type will be checked(green triangle will be shown for cell if the check failed).

      • setErrorCheck

        function setErrorCheck(errorCheckType, isCheck)
        Sets whether given error type will be checked.
        Parameters:
        errorCheckType: Number - A ErrorCheckType value. error type can be checked.
        isCheck: boolean - true if given error type needs to be checked(green triangle will be shown for cell if the check failed).

      • getCountOfRange

        function getCountOfRange()
        Gets the count of ranges that influenced by this setting.
        Returns:
        the count of ranges that influenced by this setting.

      • addRange

        function addRange(ca)
        Adds one influenced range by this setting.
        Parameters:
        ca: CellArea - the range to be added.
        Returns:
        the index of the added range in the range list of this setting.

      • getRange

        function getRange(index)
        Gets the influenced range of this setting by given index.
        Parameters:
        index: Number - the index of range
        Returns:
        return influenced range at given index.

      • removeRange

        function removeRange(index)
        Removes one range by given index.
        Parameters:
        index: Number - the index of the range to be removed.