ParameterValue Class

Contains data passed to the function or returned.

Namespace: DevExpress.Spreadsheet.Functions

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

Declaration

C#

public class ParameterValue

VB.NET

Public Class ParameterValue

Related API Members

The following members accept/return ParameterValue objects:

Show 12 links

• FormulaEngine.Evaluate(String)
• FormulaEngine.Evaluate(String, ExpressionContext)
• FunctionWrapper.Evaluate(IList<ParameterValue>, EvaluationContext)
• IFunction.Evaluate(IList<ParameterValue>, EvaluationContext)
• IWorkbook.Evaluate(String)
• IWorkbook.Evaluate(String, FormulaEvaluationContext)
• ParameterValue.Empty
• ParameterValue.FromDateTime(DateTime, Boolean)
• ParameterValue.FromRange(CellRange)
• ParameterValue.FromRange(List<CellRange>)
• Workbook.Evaluate(String)
• Workbook.Evaluate(String, FormulaEvaluationContext)

Remarks

The IFunction.Evaluate method gets the list of ParameterValue objects. You can determine the type of the parameter, and obtain the parameter value as an object of the proper type. If required, you can use static methods of the ParameterValue class to return an error.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ParameterValue class.

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#

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/CS/SpreadsheetAddIn/Form1.cs#L112

public ParameterValue Evaluate(IList<ParameterValue> parameters, EvaluationContext context)
{

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/CS/UDF_Discount/DiscountFunction.cs#L30

ParameterValue IFunction.Evaluate(IList<ParameterValue> parameters, EvaluationContext context)
{

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/CustomFunctionActions.cs#L88

ParameterValue IFunction.Evaluate(IList<ParameterValue> parameters, EvaluationContext context)
{

winforms-spreadsheetcontrol-api-part-2-e4832/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/CustomFunctionActions.cs#L90

ParameterValue IFunction.Evaluate(IList<ParameterValue> parameters, EvaluationContext context)
{

udf-custom-function-how-to-replace-the-built-in-worksheet-function-t124453/CS/FunctionWrapperSample/Form1.cs#L48

public override ParameterValue Evaluate(IList<ParameterValue> parameters, EvaluationContext context)
{

VB.NET

how-to-use-excel-add-ins-in-the-spreadsheet-control-e5012/VB/SpreadsheetAddIn/Form1.vb#L126

Public Function Evaluate(ByVal parameters As IList(Of ParameterValue), ByVal context As EvaluationContext) As ParameterValue Implements IFunction.Evaluate
    Dim args As New List(Of Object)()

udf-custom-function-how-to-replace-excel-xll-add-in-udf-with-a-custom-function-e5178/VB/UDF_Discount/DiscountFunction.vb#L45

Private Function Evaluate(ByVal parameters As IList(Of ParameterValue), ByVal context As EvaluationContext) As ParameterValue Implements IFunction.Evaluate
    Dim quantity As Double

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

Private Function IFunction_Evaluate(ByVal parameters As IList(Of ParameterValue), ByVal context As EvaluationContext) As ParameterValue Implements IFunction.Evaluate
    Dim radius As Double

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

Private Function IFunction_Evaluate(ByVal parameters As IList(Of ParameterValue), ByVal context As EvaluationContext) As ParameterValue Implements IFunction.Evaluate
    Dim radius As Double

udf-custom-function-how-to-replace-the-built-in-worksheet-function-t124453/VB/FunctionWrapperSample/Form1.vb#L44

Public Overrides Function Evaluate(ByVal parameters As IList(Of ParameterValue), ByVal context As EvaluationContext) As ParameterValue
    Dim value As ParameterValue = parameters(0)

Inheritance

Object

ParameterValue