XlIgnoreErrors Enum
Lists the types of errors which occur in cell formulas and can be skipped using the IXlSheet.IgnoreErrors property.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.2.Core.dll
NuGet Package: DevExpress.Printing.Core
#Declaration
#Members
Name | Description |
---|---|
None
|
No errors are ignored. |
Calculated
|
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®. |
Empty
|
The formula contains a reference to an empty cell. The screenshot that illustrates this error type is taken in Microsoft® Excel®. |
Evaluation
|
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®. |
Formula
|
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®. |
List
|
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®. |
Number
|
Numbers stored as text or preceded by an apostrophe. The screenshot that illustrates this error type is taken in Microsoft® Excel®. |
Two
|
A text date that might be misinterpreted as the wrong century. The screenshot that illustrates this error type is taken in Microsoft® Excel®. |
Unlocked
|
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. |
#Related API Members
The following properties accept/return XlIgnoreErrors values: