CellValue.NumericValue Property

Returns a number contained in a cell.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public double NumericValue { get; }

VB.NET

Public ReadOnly Property NumericValue As Double

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.

Related GitHub Examples

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.

C#

winforms-spreadsheetcontrol-api-part-3-t231273/CS/SpreadsheetControl_API_Part03/CodeExamples/RowAndColumnActions.cs#L14

// Create a function specifying the condition to remove worksheet rows.
Func<int, bool> rowRemovalCondition = x => worksheet.Cells[x, 0].Value.NumericValue > 3.0 && worksheet.Cells[x, 0].Value.NumericValue < 14.0;

spreadsheet-how-to-perform-a-request-to-the-server-using-jqueryajax-to-get-cell-values-t318446/CS/T318446/Controllers/HomeController.cs#L20

IWorkbook myWorkBook = SpreadsheetExtension.GetCurrentDocument("Spreadsheet");
int test = Convert.ToInt32(myWorkBook.Worksheets[0].Cells["B3"].Value.NumericValue);
return Json(test);

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538369/CS/CustomFunctionReturningArrayExample/TestArrayCustomFunction.cs#L32

for (int m = 0; m < result.GetLength(1); m++) {
    double coeff = (args[n, m].NumericValue == 0) ? 1 : args[n, m].NumericValue;
    result[n, m] = (n+1)*(m+1)*coeff;

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538770/CS/CustomFunctionReturningArrayExample/TestArrayCustomFunction.cs#L28

for (int m = 0; m < result.GetLength(1); m++) {
    double coeff = (args[n, m].NumericValue == 0) ? 1 : args[n, m].NumericValue;
    result[n, m] = (n + 1) * (m + 1) * coeff;

VB.NET

winforms-spreadsheetcontrol-api-part-3-t231273/VB/SpreadsheetControl_API_Part03/CodeExamples/RowAndColumnActions.vb#L15

' Create a function specifying the condition to remove worksheet rows.
Dim rowRemovalCondition As Func(Of Integer, Boolean) = Function(x) worksheet.Cells(x, 0).Value.NumericValue > 3.0 AndAlso worksheet.Cells(x, 0).Value.NumericValue < 14.0

spreadsheet-how-to-perform-a-request-to-the-server-using-jqueryajax-to-get-cell-values-t318446/VB/T318446/Controllers/HomeController.vb#L20

Dim myWorkBook As IWorkbook = SpreadsheetExtension.GetCurrentDocument("Spreadsheet")
Dim test As Integer = Convert.ToInt32(myWorkBook.Worksheets(0).Cells("B3").Value.NumericValue)
Return Json(test)

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538369/VB/CustomFunctionReturningArrayExample/TestArrayCustomFunction.vb#L52

For m As Integer = 0 To result.GetLength(1) - 1
    Dim coeff As Double = If(args(n, m).NumericValue = 0, 1, args(n, m).NumericValue)
    result(n, m) = (n+1)*(m+1)*coeff

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538770/VB/CustomFunctionReturningArrayExample/TestArrayCustomFunction.vb#L45

For m As Integer = 0 To result.GetLength(1) - 1
    Dim coeff As Double = If(args(n, m).NumericValue = 0, 1, args(n, m).NumericValue)
    result(n, m) = (n + 1) * (m + 1) * coeff