Back to Devexpress

Workbook.Evaluate(String, FormulaEvaluationContext) Method

officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-evaluate-x28-system-dot-string-devexpress-dot-spreadsheet-dot-functions-dot-formulaevaluationcontext-x29.md

latest2.4 KB
Original Source

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

csharp
public ParameterValue Evaluate(
    string formula,
    FormulaEvaluationContext context
)
vb
Public Function Evaluate(
    formula As String,
    context As FormulaEvaluationContext
) As ParameterValue

Parameters

NameTypeDescription
formulaString

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

TypeDescription
ParameterValue

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