Skip to main content
Row

CellValue.NumericValue Property

Returns a number contained in a cell.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

public double NumericValue { get; }

Property Value

Type Description
Double

A Double value specifying a cell value of the numeric type.

Remarks

Use the NumericValue property to obtain the number contained in a cell. To check whether the cell value is of the numeric type, use the CellValue.IsNumeric or CellValue.Type property. To get a string that specifies a numeric value as it is displayed in the cell according to the applied number format, use the Cell.DisplayText property.

Note

Note, that dates and times are stored in cells as numbers that are displayed according to the applied date and time formats. So, if a cell contains a number, the CellValue.DateTimeValue property returns the DateTime object, which specifies a date and time value corresponding to that number.

For more information on cell values, refer to the Cell Data Types document.

The following code snippets (auto-collected from DevExpress Examples) contain references to the NumericValue 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.

See Also