IgnoredErrorType Enum
Lists types of errors which occur in cell formulas and can be ignored using the Worksheet.IgnoredErrors property.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Members
Name | Description |
---|---|
None
|
No errors are ignored. |
InconsistentColumnFormula
|
A calculated column includes formulas that are different from the column formula. The screenshot that illustrates this type of error is taken with Microsoft Excel. |
InconsistentFormula
|
The formula does not match the pattern of other formulas near it. The screenshot that illustrates this type of error is taken with 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 type of error is taken with Microsoft Excel. |
TextDate
|
A text date that might be misinterpreted as the wrong century. The screenshot that illustrates this type of error is taken with Microsoft Excel. |
EmptyCellReferences
|
The formula contains a reference to an empty cell. The screenshot that illustrates this type of error is taken with Microsoft Excel. |
ListDataValidation
|
A cell value does not comply with the Data Validation rule that restricts data to predefined items in a list. The screenshot that illustrates this type of error is taken with Microsoft Excel. |
EvaluateToError
|
The 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. The screenshot that illustrates this type of error is taken with Microsoft Excel. |
UnlockedFormula
|
The cell containing formula is not locked for protection. The screenshot that illustrates this type of error is taken with Microsoft Excel. |