ErrorCheckType

ErrorCheckType enumeration

Represents all error check type.

Values

NameValueDescription
EvaluationError1Ignore errors when cells contain formulas that result in an error.
Calc1
EmptyCellRef2Ignore errors when formulas refer to empty cells.
NumberStoredAsText4Ignore errors when numbers are formatted as text or are preceded by an apostrophe
TextNumber4Ignore errors when numbers are formatted as text or are preceded by an apostrophe
InconsistRange8Ignore errors when formulas omit certain cells in a region.
InconsistFormula16Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
TwoDigitTextYear32Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
TextDate32Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
UnlockedFormula64Ignore errors when unlocked cells contain formulas.
UnproctedFormula64Ignore errors when unlocked cells contain formulas.
TableDataValidation128Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
Validation128Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
CalculatedColumn129Ignore errors when cells contain a value different from a calculated column formula.