aspose.cells

aspose.cells

Class ErrorCheckType

Utility class containing constants. Represents all error check type.

Field Summary
const  NumberCALC
check for calculation errors
const  NumberEMPTY_CELL_REF
check for references to empty cells
const  NumberTEXT_NUMBER
check the format of numeric values
const  NumberINCONSIST_RANGE
check formulas with references to less than the entirety of a range containing continuous data
const  NumberINCONSIST_FORMULA
check formulas that are inconsistent with formulas in neighboring cells.
const  NumberTEXT_DATE
check the format of date/time values
const  NumberUNPROCTED_FORMULA
check for unprotected formulas
const  NumberVALIDATION
whether to perform data validation
const  NumberCALCULATED_COLUMN
Ignore errors when cells contain a value different from a calculated column formula.
 

    • Field Detail

      • CALC

        const Number CALC
        check for calculation errors

      • EMPTY_CELL_REF

        const Number EMPTY_CELL_REF
        check for references to empty cells

      • TEXT_NUMBER

        const Number TEXT_NUMBER
        check the format of numeric values

      • INCONSIST_RANGE

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

      • INCONSIST_FORMULA

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

      • TEXT_DATE

        const Number TEXT_DATE
        check the format of date/time values

      • UNPROCTED_FORMULA

        const Number UNPROCTED_FORMULA
        check for unprotected formulas

      • VALIDATION

        const Number VALIDATION
        whether to perform data validation

      • CALCULATED_COLUMN

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