[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IgnoredErrorType

IgnoredErrorType Enum

The types of errors that can occur in cell.

Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
[Flags]
public enum IgnoredErrorType
<Flags>
Public Enum IgnoredErrorType

Fields

Name Description
All

Ignore all types of errors.

EmptyCellReferences

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

EvaluateToError

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

InconsistentFormula

Ignore the error of discrepancies in formulas within a range.

InconsistentListFormula

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

ListDataValidation

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

No errors are ignored.

NumberAsText

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

OmittedCells

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

TextDate

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

UnlockedFormulaCells

Ignore the error in unlocked cells containing formulas.