Skip to main content

PivotGridOptionsBehavior.ExpressionEditorMode Property

Gets or sets the type of editor that end-users can invoke to modify expressions for calculated fields.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid


public ExpressionEditorMode ExpressionEditorMode { get; set; }

Property Value

Type Default Description
ExpressionEditorMode Default

An ExpressionEditorMode object that specifies the editor type.

Available values:

Name Description

Editor version depends on the WindowsFormsSettings.DefaultSettingsCompatibilityMode value. If its value is v16 or less, it is the legacy version; otherwise, the new version is used.


Specifies a legacy version of the Expression editor.


Specifies a new version of the Expression editor.

Property Paths

You can access this nested property as listed below:

Object Type Path to ExpressionEditorMode
.OptionsBehavior .ExpressionEditorMode


To switch to a new version of the Expression Editor, set the ExpressionEditorMode property to ExpressionEditorMode.AutoComplete.

You can allow users to edit or create new custom expressions in the Expression Editor at runtime. To accomplish this, set the PivotGridFieldOptionsEx.ShowExpressionEditorMenu property to true to add the Expression Editor command to the field’s context menu or call the ShowExpressionEditor method to invoke the Expression Editor.


You cannot use the Expression Editor dialog in OLAP mode.

See Also