CellValue.ErrorValue Property

Returns an object that provides information on an error contained in a cell.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public ErrorValueInfo ErrorValue { get; }

VB.NET

Public ReadOnly Property ErrorValue As ErrorValueInfo

Property Value

Type	Description
ErrorValueInfo	An ErrorValueInfo object that contains information on a cell error.

Remarks

Use the ErrorValue property to obtain the error contained in a cell. To determine whether the cell value is of the error type, use the CellValue.IsError or CellValue.Type property.

For more information on cell values, refer to the Cell Data Types and Error Types documents.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ErrorValue property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-use-excel-add-ins-in-winforms-spreadsheet/CS/SpreadsheetAddIn/Form1.cs#L83

foreach (KeyValuePair<int, DevExpress.Spreadsheet.CellValue> pair in ErrorToValueDictonary)
    result.Add(pair.Value.ErrorValue, pair.Key);
return result;

VB.NET

how-to-use-excel-add-ins-in-winforms-spreadsheet/VB/SpreadsheetAddIn/Form1.vb#L79

For Each pair As KeyValuePair(Of Integer, DevExpress.Spreadsheet.CellValue) In ErrorToValueDictonary
    result.Add(pair.Value.ErrorValue, pair.Key)
Next pair