IXlSheet.IgnoreErrors Property

Gets or sets the type of a formula error to be skipped in the worksheet data range.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll

Declaration

XlIgnoreErrors IgnoreErrors { get; set; }

Property Value

Type Description
XlIgnoreErrors

An XlIgnoreErrors enumeration value that specifies the error type to be ignored.

Available values:

Show 11 items
Name Description
None

No errors are ignored.

CalculatedColumn

The cell in a calculated column contains a formula that is different from the calculated column formula.

IgnoredErrorType.InconsistentColumnFormula

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

EmptyCellReference

The formula contains a reference to an empty cell.

IgnoredErrorType.EmptyCellReferences

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

EvaluationError

The cell contains a formula that results in an error. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

Formula

The formula does not match the pattern of nearby formulas.

IgnoredErrorType.InconsistentFormula

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

FormulaRange

The formula omits certain cells in a region. The rule checks whether the formula in the cell which references a cell range includes a range of cells that is adjacent to the cell that contains the formula.

IgnoredErrorType.FormulaRange

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

ListDataValidation

A cell value does not comply with the data validation rule restricting data to predefined items in a list.

IgnoredErrorType.ListDataValidation

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

NumberStoredAsText

Numbers stored as text or preceded by an apostrophe.

IgnoredErrorType.NumberAsText

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

TwoDigitTextYear

A text date that might be misinterpreted as the wrong century.

IgnoredErrorType.TextDate

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

UnlockedFormula

The cell containing a formula is not locked for protection.

IgnoredErrorType.UnlockedFormula

The screenshot that illustrates this error type is taken in Microsoft® Excel®.

Any

All errors are ignored.

See Also