asposecells.api

Class ErrorCheckType

Utility class containing constants. Represents all error check type.

Field Summary
const  intEVALUATION_ERROR
Ignore errors when cells contain formulas that result in an error.
const  intCALC
const  intEMPTY_CELL_REF
Ignore errors when formulas refer to empty cells.
const  intNUMBER_STORED_AS_TEXT
Ignore errors when numbers are formatted as text or are preceded by an apostrophe
const  intTEXT_NUMBER
Ignore errors when numbers are formatted as text or are preceded by an apostrophe
const  intINCONSIST_RANGE
Ignore errors when formulas omit certain cells in a region.
const  intINCONSIST_FORMULA
Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
const  intTWO_DIGIT_TEXT_YEAR
Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
const  intTEXT_DATE
Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
const  intUNLOCKED_FORMULA
Ignore errors when unlocked cells contain formulas.
const  intUNPROCTED_FORMULA
Ignore errors when unlocked cells contain formulas.
const  intTABLE_DATA_VALIDATION
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
const  intVALIDATION
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
const  intCALCULATED_COLUMN
Ignore errors when cells contain a value different from a calculated column formula.
 

    • Field Detail

      • EVALUATION_ERROR

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

        const int 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 int EMPTY_CELL_REF
        Ignore errors when formulas refer to empty cells.
      • NUMBER_STORED_AS_TEXT

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

        const int 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 int INCONSIST_RANGE
        Ignore errors when formulas omit certain cells in a region.
      • INCONSIST_FORMULA

        const int 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 int TWO_DIGIT_TEXT_YEAR
        Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
      • TEXT_DATE

        const int 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 int UNLOCKED_FORMULA
        Ignore errors when unlocked cells contain formulas.
      • UNPROCTED_FORMULA

        const int 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 int TABLE_DATA_VALIDATION
        Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
      • VALIDATION

        const int 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 int CALCULATED_COLUMN
        Ignore errors when cells contain a value different from a calculated column formula.