GrapeCity.Documents.Excel.IgnoredErrorType

Enum IgnoredErrorType

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

The types of errors that can occur in cell.

[Flags]
public enum IgnoredErrorType

Fields

All = InconsistentListFormula | InconsistentFormula | OmittedCells | TextDate | EmptyCellReferences | ListDataValidation | EvaluateToError | NumberAsText | UnlockedFormulaCells

Ignore all types of errors.

EmptyCellReferences = 16

Ignore the error when formula contains a reference to an empty cell.

EvaluateToError = 64

Ignore the error of the formula result error.
Formula result error types include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

InconsistentFormula = 2

Ignore the error of discrepancies in formulas within a range.

InconsistentListFormula = 1

Ignore the error of discrepancies in formulas within a calculated column.

ListDataValidation = 32

Ignore the error of cell value that does not comply with the Data Validation rule that restricts data to predefined items in a list.

None = 0

No errors are ignored.

NumberAsText = 128

Ignore the error in cells containing numbers stored as text or preceded by an apostrophe.

OmittedCells = 4

Ignore the error in cells containing formulas referring to a range that omits adjacent cells that could be included.

TextDate = 8

Ignore the error when formulas contain text formatted cells with years misinterpreted as the wrong century.

UnlockedFormulaCells = 256

Ignore the error in unlocked cells containing formulas.