IWorkbook.Evaluate(String, FormulaEvaluationContext) Method

Evaluates the specified formula in a certain context.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ParameterValue Evaluate(
    string formula,
    FormulaEvaluationContext context
)

VB.NET

Function Evaluate(
    formula As String,
    context As FormulaEvaluationContext
) As ParameterValue

Parameters

Name	Type	Description
formula	String	A string that represents the formula to be evaluated.
context	FormulaEvaluationContext	A FormulaEvaluationContext object containing information on the row, column and the current culture settings.

Returns

Type	Description
ParameterValue	A ParameterValue object that is the calculation result and may contain a value, a reference or a calculation error.