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.v25.2.dll

NuGet Package : DevExpress.Win.PivotGrid

Declaration

csharp

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

<DefaultValue(ExpressionEditorMode.Default)>
<XtraSerializableProperty>
Public Property ExpressionEditorMode As ExpressionEditorMode

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.

You can access this nested property as listed below:

Object Type	Path to ExpressionEditorMode
PivotGridControl

.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.

Note

You cannot use the Expression Editor dialog in OLAP mode.