Cell.ParsedExpression Property

Gets or sets the expression tree from which the formula entered in the cell is built.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

ParsedExpression ParsedExpression { get; set; }

VB.NET

Property ParsedExpression As ParsedExpression

Property Value

Type	Description
ParsedExpression	A ParsedExpression object that contains an expression tree.

Remarks

The ParsedExpression property provides you with access to an expression tree created from a formula contained in the worksheet cell.

You can also use the FormulaEngine.Parse method to create an expression tree from a string formula (which does not have to be entered in the cell) and pass the ExpressionContext object to specify a cell and a worksheet.

Related GitHub Examples

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

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#

spreadsheet-use-concatenate-function-to-update-long-strings-in-formulas/CS/SpreadsheetApp/Form1.cs#L25

var walker = new ReplaceLongStringsWalker(workbook);
var parsedExpression = cell.ParsedExpression;
walker.Walk(parsedExpression);

VB.NET

spreadsheet-use-concatenate-function-to-update-long-strings-in-formulas/VB/SpreadsheetApp/Form1.vb#L21

Dim walker = New ReplaceLongStringsWalker(workbook)
Dim parsedExpression = cell.ParsedExpression
walker.Walk(parsedExpression)