corelibraries-devexpress-dot-export-dot-xl-dot-ixlsheet.md
Gets or sets the type of a formula error to be skipped in the worksheet data range.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
XlIgnoreErrors IgnoreErrors { get; set; }
Property IgnoreErrors As XlIgnoreErrors
| 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.
The screenshot that illustrates this error type is taken in Microsoft® Excel®.
| | EmptyCellReference |
The formula contains a reference to an empty cell.
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.
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.
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.
The screenshot that illustrates this error type is taken in Microsoft® Excel®.
| | NumberStoredAsText |
Numbers stored as text or preceded by an apostrophe.
The screenshot that illustrates this error type is taken in Microsoft® Excel®.
| | TwoDigitTextYear |
A text date that might be misinterpreted as the wrong century.
The screenshot that illustrates this error type is taken in Microsoft® Excel®.
| | UnlockedFormula |
The cell containing a formula is not locked for protection.
The screenshot that illustrates this error type is taken in Microsoft® Excel®.
| | Any |
All errors are ignored.
|
See Also