IgnoredErrorType Enum
Lists types of errors that can occur in cell formulas. Use the Worksheet.IgnoredErrors property to ignore these errors.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Members
| Name | Description | Example |
|---|---|---|
None
|
No errors are ignored. |
|
InconsistentColumnFormula
|
A calculated column includes formulas that are different from the column formula. |
|
InconsistentFormula
|
The formula does not match the pattern of other formulas near it. |
|
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. |
|
TextDate
|
A text date that might be misinterpreted as the wrong century. |
|
EmptyCellReferences
|
The formula contains a reference to an empty cell. |
|
ListDataValidation
|
A cell value does not comply with the Data Validation rule that restricts data to predefined items in a list. |
|
EvaluateToError
|
A cell contains a formula that results in an error. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. |
|
NumberAsText
|
Numbers stored as text or preceded by an apostrophe. |
|
UnlockedFormula
|
A cell with a formula is not locked for protection. |
|
All
|
All errors are ignored. |
Related API Members
The following properties accept/return IgnoredErrorType values: