EvaluationContext Interface

Provides information on the worksheet, its current culture, the column and the row containing the cell for which a formula is calculated.

Namespace: DevExpress.Spreadsheet.Functions

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

Declaration

C#

public interface EvaluationContext

VB.NET

Public Interface EvaluationContext

Remarks

The EvaluationContext object contains information on the context in which the formula containing a custom function is calculated.

Related GitHub Examples

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

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)
{

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)
{

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)
{

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

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)

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