ExpressionContext Class

Contains formula environment information - the cell or range, the worksheet, the current culture, the reference style, and indicates whether the formula is an array formula.

Namespace: DevExpress.Spreadsheet.Formulas

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

Declaration

C#

public class ExpressionContext :
    IExpressionContext,
    EvaluationContext

VB.NET

Public Class ExpressionContext
    Implements IExpressionContext,
               EvaluationContext

Remarks

The ExpressionContext is required for correct formula evaluation and parsing in the FormulaEngine.Evaluate and FormulaEngine.Parse methods. It determines multiple parameters on which the worksheet formula depends.

If the ExpressionContext instance is not explicitly specified, the active cell in the active worksheet is the expression context.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExpressionContext 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#L67

// Create the expression context.
ExpressionContext context = new ExpressionContext(columnIndex, rowIndex, this.contextSheet,
    CultureInfo.GetCultureInfo("en-US"), ReferenceStyle.R1C1, DevExpress.Spreadsheet.Formulas.ExpressionStyle.Normal);

VB.NET

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

' Create the expression context.
Dim context As New ExpressionContext(columnIndex, rowIndex, Me.contextSheet, CultureInfo.GetCultureInfo("en-US"), ReferenceStyle.R1C1, DevExpress.Spreadsheet.Formulas.ExpressionStyle.Normal)
' Evaluate the expression.

Implements

IExpressionContext

EvaluationContext

Inheritance

Object

ExpressionContext