aspose.cells

Class ErrorCheckType

Utility class containing constants. Represents all error check type.

Field Summary
const  NumberEVALUATION_ERROR
Ignore errors when cells contain formulas that result in an error.
const  NumberCALC
const  NumberEMPTY_CELL_REF
Ignore errors when formulas refer to empty cells.
const  NumberNUMBER_STORED_AS_TEXT
Ignore errors when numbers are formatted as text or are preceded by an apostrophe
const  NumberTEXT_NUMBER
Ignore errors when numbers are formatted as text or are preceded by an apostrophe
const  NumberINCONSIST_RANGE
Ignore errors when formulas omit certain cells in a region.
const  NumberINCONSIST_FORMULA
Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
const  NumberTWO_DIGIT_TEXT_YEAR
Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
const  NumberTEXT_DATE
Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
const  NumberUNLOCKED_FORMULA
Ignore errors when unlocked cells contain formulas.
const  NumberUNPROCTED_FORMULA
Ignore errors when unlocked cells contain formulas.
const  NumberTABLE_DATA_VALIDATION
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
const  NumberVALIDATION
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
const  NumberCALCULATED_COLUMN
Ignore errors when cells contain a value different from a calculated column formula.
 

    • Field Detail

      • EVALUATION_ERROR

        const Number EVALUATION_ERROR
        Ignore errors when cells contain formulas that result in an error.
      • CALC

        const Number CALC
        NOTE: This member is now obsolete. Instead, please use ErrorCheckType.EvaluationError enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
      • EMPTY_CELL_REF

        const Number EMPTY_CELL_REF
        Ignore errors when formulas refer to empty cells.
      • NUMBER_STORED_AS_TEXT

        const Number NUMBER_STORED_AS_TEXT
        Ignore errors when numbers are formatted as text or are preceded by an apostrophe
      • TEXT_NUMBER

        const Number TEXT_NUMBER
        Ignore errors when numbers are formatted as text or are preceded by an apostrophe NOTE: This member is now obsolete. Instead, please use ErrorCheckType.NumberStoredAsText enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
      • INCONSIST_RANGE

        const Number INCONSIST_RANGE
        Ignore errors when formulas omit certain cells in a region.
      • INCONSIST_FORMULA

        const Number INCONSIST_FORMULA
        Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
      • TWO_DIGIT_TEXT_YEAR

        const Number TWO_DIGIT_TEXT_YEAR
        Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
      • TEXT_DATE

        const Number TEXT_DATE
        Ignore errors when formulas contain text formatted cells with years represented as 2 digits. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TwoDigitTextYear enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
      • UNLOCKED_FORMULA

        const Number UNLOCKED_FORMULA
        Ignore errors when unlocked cells contain formulas.
      • UNPROCTED_FORMULA

        const Number UNPROCTED_FORMULA
        Ignore errors when unlocked cells contain formulas. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.UnproctedFormula enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
      • TABLE_DATA_VALIDATION

        const Number TABLE_DATA_VALIDATION
        Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
      • VALIDATION

        const Number VALIDATION
        Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TableDataValidation enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
      • CALCULATED_COLUMN

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