ErrorCheckType

ErrorCheckType enumeration

Utility class containing constants. Represents all error check type.

Values

NameDescription
EVALUATION_ERRORIgnore errors when cells contain formulas that result in an error.
CALCNOTE: 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_REFIgnore errors when formulas refer to empty cells.
NUMBER_STORED_AS_TEXTIgnore errors when numbers are formatted as text or are preceded by an apostrophe
TEXT_NUMBERIgnore 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_RANGEIgnore errors when formulas omit certain cells in a region.
INCONSIST_FORMULAIgnore errors when a formula in a region of your worksheet differs from other formulas in the same region.
TWO_DIGIT_TEXT_YEARIgnore errors when formulas contain text formatted cells with years represented as 2 digits.
TEXT_DATEIgnore 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_FORMULAIgnore errors when unlocked cells contain formulas.
UNPROCTED_FORMULAIgnore 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_VALIDATIONIgnore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
VALIDATIONIgnore 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_COLUMNIgnore errors when cells contain a value different from a calculated column formula.