ErrorCheckType enumeration

Represents all error check type.

public enum ErrorCheckType


Name Value Description
Calc 1 check for calculation errors
EmptyCellRef 2 check for references to empty cells
TextNumber 4 check the format of numeric values
InconsistRange 8 check formulas with references to less than the entirety of a range containing continuous data
InconsistFormula 16 check formulas that are inconsistent with formulas in neighboring cells.
TextDate 32 check the format of date/time values
UnproctedFormula 64 check for unprotected formulas
Validation 128 whether to perform data validation
CalculatedColumn 129 Ignore errors when cells contain a value different from a calculated column formula.

See Also