XlIgnoreErrors Enum

Lists the types of errors which occur in cell formulas and can be skipped using the IXlSheet.IgnoreErrors property.

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

Declaration

C#
VB.NET

[Flags]
public enum XlIgnoreErrors

<Flags>
Public Enum XlIgnoreErrors

Members

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.