ParsedExpression Class

Contains an expression tree and provides methods to handle it.

Namespace: DevExpress.Spreadsheet.Formulas

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

Declaration

C#

public class ParsedExpression :
    IParsedExpression

VB.NET

Public Class ParsedExpression
    Implements IParsedExpression

Related API Members

The following members accept/return ParsedExpression objects:

• Cell.ParsedExpression
• DefinedName.ParsedExpression
• FormulaEngine.Parse(String)
• FormulaEngine.Parse(String, ExpressionContext)

Remarks

The ParsedExpression object is returned by the FormulaEngine.Parse method, by using the Cell.ParsedExpression or the DefinedName.ParsedExpression properties.

The ParsedExpression.GetRanges method can be used to obtain cell ranges referenced in the formula. The ParsedExpression.ToString method can be used to create a string expression from the expression tree (reverting the FormulaEngine.Parse method).

Related GitHub Examples

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

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#L87

// Parse the formula
ParsedExpression p_expr = engine.Parse(formula);
// Traverse the expression tree and modify it.

VB.NET

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

' Parse the formula
Dim p_expr As ParsedExpression = engine.Parse(formula)
' Traverse the expression tree and modify it.

Inheritance

Object

ParsedExpression