Skip to main content
Row

IgnoredError.Type Property

Gets the type of error being ignored.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

IgnoredErrorType Type { get; }

Property Value

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.

IgnoredErrorType.InconsistentColumnFormula

InconsistentFormula

The formula does not match the pattern of other formulas near it.

IgnoredErrorType.InconsistentFormula

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.

IgnoredErrorType.FormulaRange

TextDate

A text date that might be misinterpreted as the wrong century.

IgnoredErrorType.TextDate

EmptyCellReferences

The formula contains a reference to an empty cell.

IgnoredErrorType.EmptyCellReferences

ListDataValidation

A cell value does not comply with the Data Validation rule that restricts data to predefined items in a list.

IgnoredErrorType.ListDataValidation

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.

IgnoredErrorType.NumberAsText

UnlockedFormula

A cell with a formula is not locked for protection.

IgnoredErrorType.UnlockedFormula

All

All errors are ignored.

See Also