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.v24.2.Core.dll

Declaration

C#

XlIgnoreErrors IgnoreErrors { get; set; }

VB.NET

Property IgnoreErrors As XlIgnoreErrors

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. 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.