FormulaEngine Interface

An object that provides the capability to calculate and parse worksheet formulas.

Namespace: DevExpress.Spreadsheet.Formulas

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

Declaration

C#

public interface FormulaEngine

VB.NET

Public Interface FormulaEngine

Related API Members

The following members accept/return FormulaEngine objects:

Library	Related API Members
Cross-Platform Class Library	IWorkbook.FormulaEngine
Office File API	Workbook.FormulaEngine

Remarks

The FormulaEngine includes a built-in formula parser, as well as the flexibility to evaluate formulas in any range of any worksheet using the FormulaEngine.Evaluate method. You can parse a formula using the FormulaEngine.Parse method, analyze the resulting expression tree, make the required modifications and rebuild the formula string from the modified expression tree using the ParsedExpression.ToString method.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the FormulaEngine interface.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

formula-engine-examples-of-use-t110344/CS/FormulaEngineTest/Form1.cs#L62

#region #evaluate
FormulaEngine engine = spreadsheetControl1.Document.FormulaEngine;
// Get coordinates of the context cell.

VB.NET

formula-engine-examples-of-use-t110344/VB/FormulaEngineTest/Form1.vb#L58

'            #Region "#evaluate"
            Dim engine As FormulaEngine = spreadsheetControl1.Document.FormulaEngine
            ' Get coordinates of the context cell.