Back to Devexpress

CellValue.ErrorValue Property

officefileapi-devexpress-dot-spreadsheet-dot-cellvalue-ab97ab04.md

latest3.6 KB
Original Source

CellValue.ErrorValue Property

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

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public ErrorValueInfo ErrorValue { get; }
vb
Public ReadOnly Property ErrorValue As ErrorValueInfo

Property Value

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

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.

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

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

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

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

See Also

IsError

BooleanValue

DateTimeValue

TextValue

NumericValue

Cell Data Types

CellValue Class

CellValue Members

DevExpress.Spreadsheet Namespace