ErrorCheckType enumeration

ErrorCheckType enumeration

Represents all error check type.

The ErrorCheckType type exposes the following members:

Fields

FieldDescription
EVALUATION_ERRORIgnore errors when cells contain formulas that result in an error.
CALC
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
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.
UNLOCKED_FORMULAIgnore errors when unlocked cells contain formulas.
UNPROCTED_FORMULAIgnore errors when unlocked cells contain formulas.
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.
CALCULATED_COLUMNIgnore errors when cells contain a value different from a calculated column formula.

See Also