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