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.v25.2.dll

NuGet Package : DevExpress.Document.Processor

Declaration

• C#
• VB.NET

public ParameterValue Evaluate(
    string formula,
    FormulaEvaluationContext context
)

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

Parameters

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

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

|

Implements

Evaluate(String, FormulaEvaluationContext)

See Also

Workbook Class

Workbook Members

DevExpress.Spreadsheet Namespace