asposecells.api

asposecells.api

Class ErrorCheckType

Utility class containing constants. Represents all error check type.

Field Summary
const  intCALC
check for calculation errors
const  intEMPTY_CELL_REF
check for references to empty cells
const  intTEXT_NUMBER
check the format of numeric values
const  intINCONSIST_RANGE
check formulas with references to less than the entirety of a range containing continuous data
const  intINCONSIST_FORMULA
check formulas that are inconsistent with formulas in neighboring cells.
const  intTEXT_DATE
check the format of date/time values
const  intUNPROCTED_FORMULA
check for unprotected formulas
const  intVALIDATION
whether to perform data validation
const  intCALCULATED_COLUMN
Ignore errors when cells contain a value different from a calculated column formula.
 

    • Field Detail

      • CALC

        const int CALC
        check for calculation errors

      • EMPTY_CELL_REF

        const int EMPTY_CELL_REF
        check for references to empty cells

      • TEXT_NUMBER

        const int TEXT_NUMBER
        check the format of numeric values

      • INCONSIST_RANGE

        const int INCONSIST_RANGE
        check formulas with references to less than the entirety of a range containing continuous data

      • INCONSIST_FORMULA

        const int INCONSIST_FORMULA
        check formulas that are inconsistent with formulas in neighboring cells.

      • TEXT_DATE

        const int TEXT_DATE
        check the format of date/time values

      • UNPROCTED_FORMULA

        const int UNPROCTED_FORMULA
        check for unprotected formulas

      • VALIDATION

        const int VALIDATION
        whether to perform data validation

      • CALCULATED_COLUMN

        const int CALCULATED_COLUMN
        Ignore errors when cells contain a value different from a calculated column formula.