Aspose::Cells::ErrorCheckType enum

ErrorCheckType enum

Represents all error check type.

enum class ErrorCheckType

Values

NameValueDescription
EvaluationError1
Ignore errors when cells contain formulas that result in an error.
Calc1(Deprecated - Use ErrorCheckType.EvaluationError instead. )
EmptyCellRef2
Ignore errors when formulas refer to empty cells.
NumberStoredAsText4
Ignore errors when numbers are formatted as text or are preceded by an apostrophe.
TextNumber4(Deprecated - Use ErrorCheckType.NumberStoredAsText instead. )
Ignore errors when numbers are formatted as text or are preceded by an apostrophe.
InconsistRange8
Ignore errors when formulas omit certain cells in a region.
InconsistFormula16
Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
TwoDigitTextYear32
Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
TextDate32(Deprecated - Use ErrorCheckType.TwoDigitTextYear instead. )
Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
UnlockedFormula64
Ignore errors when unlocked cells contain formulas.
UnproctedFormula64(Deprecated - Use ErrorCheckType.UnproctedFormula instead. )
Ignore errors when unlocked cells contain formulas.
TableDataValidation128
Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
Validation128(Deprecated - Use ErrorCheckType.TableDataValidation instead. )
Ignore errors when a cell’s value in a Table does not comply with the Data Validation rules specified.
CalculatedColumn129
Ignore errors when cells contain a value different from a calculated column formula.

See Also