Back to Devexpress

IWorkbook.Evaluate(String, FormulaEvaluationContext) Method

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

latest1.9 KB
Original Source

IWorkbook.Evaluate(String, FormulaEvaluationContext) Method

Evaluates the specified formula in a certain context.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

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

Parameters

NameTypeDescription
formulaString

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

TypeDescription
ParameterValue

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

|

See Also

IWorkbook Interface

IWorkbook Members

DevExpress.Spreadsheet Namespace