The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

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

[Flags]
public enum IgnoredErrorType
<Flags>
Public Enum IgnoredErrorType
[Flags]
public enum IgnoredErrorType
<Flags>
Public Enum IgnoredErrorType

Members

Name Description
EmptyCellReferences

The formula contains a reference to an empty cell.

IgnoredErrorType.EmptyCellReferences

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!.

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

The screenshot that illustrates this type of error is taken with Microsoft Excel.

InconsistentColumnFormula

A calculated column includes formulas that are different from the column formula.

IgnoredErrorType.InconsistentColumnFormula

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.

IgnoredErrorType.InconsistentFormula

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.

IgnoredErrorType.ListDataValidation

The screenshot that illustrates this type of error is taken with Microsoft Excel.

None

No errors are ignored.

NumberAsText

Numbers stored as text or preceded by an apostrophe.

IgnoredErrorType.NumberAsText

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.

IgnoredErrorType.TextDate

The screenshot that illustrates this type of error is taken with Microsoft Excel.

UnlockedFormula

The cell containing formula is not locked for protection.

IgnoredErrorType.UnlockedFormula

The screenshot that illustrates this type of error is taken with Microsoft Excel.

See Also