CellValue.IsNumeric Property

Gets whether the cell contains a number.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public bool IsNumeric { get; }

VB.NET

Public ReadOnly Property IsNumeric As Boolean

Property Value

Type	Description
Boolean	true, if the cell value is of the numeric type; otherwise, false

Remarks

You can also use the CellValue.Type property to obtain the cell value type. This property returns CellValueType.Numeric, if a cell value is a number.

To get the number contained in a cell, use the CellValue.NumericValue property. For more information on cell values, refer to the Cell Data Types document.

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 displays a date and time value, both IsNumeric and CellValue.IsDateTime properties return true and the CellValue.Type property returns CellValueType.DateTime. The CellValue.NumericValue property returns a number contained in a cell, and the CellValue.DateTimeValue property returns the DateTime object, which specifies a date and time value represented by that number.

Related GitHub Examples

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

spreadsheet-document-api-use-worksheet-table-as-data-source/CS/SpreadsheetDocumentServerAsDataSourceExample/MyColumnDetector.cs#L24

if (value.IsDateTime) return typeof(DateTime);
if (value.IsNumeric) return typeof(double);
return defaultType;

winforms-spreadsheet-use-cell-range-as-data-source/CS/RangeDataSource/MyColumnDetector.cs#L24

if (value.IsDateTime) return typeof(DateTime);
if (value.IsNumeric) return typeof(double);
return defaultType;

VB.NET

spreadsheet-document-api-use-worksheet-table-as-data-source/VB/SpreadsheetDocumentServerAsDataSourceExample/MyColumnDetector.vb#L30

End If
If value.IsNumeric Then
    Return GetType(Double)

winforms-spreadsheet-use-cell-range-as-data-source/VB/RangeDataSource/MyColumnDetector.vb#L22

If value.IsDateTime Then Return GetType(Date)
If value.IsNumeric Then Return GetType(Double)
Return defaultType