Workbook.Evaluate(String, FormulaEvaluationContext) Method

Evaluates the specified formula in a certain context.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v23.2.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

public ParameterValue Evaluate(
    string formula,
    FormulaEvaluationContext context
)

VB.NET

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

Parameters

Name	Type	Description
formula	String	A string that is 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.

Implements

Evaluate(String, FormulaEvaluationContext)