ParameterValue.NumericValue Property

Gets or sets the numeric value of the parameter.

Namespace: DevExpress.Spreadsheet.Functions

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public double NumericValue { get; set; }

VB.NET

Public Property NumericValue As Double

Property Value

Type	Description
Double	A Double value that is used as the numeric value of the parameter.

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-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/CustomFunctionActions.cs#L103

    else
        density = densityParameter.NumericValue;
}

winforms-spreadsheet-custom-draw-example/CS/CustomDrawExample/Form1.cs#L98

string formula = String.Format("=RANK.AVG({0},R{1}C{2}:R{3}C{4})", cellRef, e.Cell.RowIndex + 1, 2, e.Cell.RowIndex + 1, 10);
int rank = (int)spreadsheetControl1.Document.Evaluate(formula).NumericValue;
// The DevExpress.Docs.Text.NumberInWords class requires a reference to the DevExpress.Docs assembly.

winforms-spreadsheet-use-formula-engine/CS/FormulaEngineTest/Form1.cs#L72

// Get the result.
double res = result.NumericValue;
#endregion #evaluate

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

if (parameter.IsNumeric)
    return parameter.NumericValue;
else if (parameter.IsBoolean)

VB.NET

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/CustomFunctionActions.vb#L117

Else
    density = densityParameter.NumericValue
End If

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/CustomFunctionActions.vb#L119

Else
    density = densityParameter.NumericValue
End If

winforms-spreadsheet-custom-draw-example/VB/CustomDrawExample/Form1.vb#L86

Dim formula As String = String.Format("=RANK.AVG({0},R{1}C{2}:R{3}C{4})", cellRef, e.Cell.RowIndex + 1, 2, e.Cell.RowIndex + 1, 10)
Dim rank As Integer = CInt(spreadsheetControl1.Document.Evaluate(formula).NumericValue)
' The DevExpress.Docs.Text.NumberInWords class requires a reference to the DevExpress.Docs assembly.

winforms-spreadsheet-use-formula-engine/VB/FormulaEngineTest/Form1.vb#L67

            ' Get the result.
            Dim res As Double = result.NumericValue
'            #End Region ' #evaluate

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

If parameter.IsNumeric Then
    Return parameter.NumericValue
ElseIf parameter.IsBoolean Then