officefileapi-devexpress-dot-spreadsheet-dot-ignorederror-5bb48cfb.md
Gets the type of error being ignored.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
IgnoredErrorType Type { get; }
ReadOnly Property Type As IgnoredErrorType
| Type | Description |
|---|---|
| IgnoredErrorType |
A IgnoredErrorType enumeration member specifying the error type being ignored.
|
Available values:
Show 11 items
| 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.
| |
See Also