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

Declaration

[DefaultValue(ExpressionEditorMode.Default)]
[XtraSerializableProperty]
public ExpressionEditorMode ExpressionEditorMode { get; set; }

Property Value

Type Default Description
ExpressionEditorMode Default

An ExpressionEditorMode object that specifies the editor type.

Available values:

Name Description
Default

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.

Standard

Specifies a legacy version of the Expression editor.

AutoComplete

Specifies a new version of the Expression editor.

Property Paths

You can access this nested property as listed below:

Object Type Path to ExpressionEditorMode
PivotGridControl
.OptionsBehavior .ExpressionEditorMode

Remarks

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.

Note

You cannot use the Expression Editor dialog in OLAP mode.

See Also