PivotGridFieldOptionsEx.FieldFilterPopupMode Property

Gets or sets the field’s pop-up filter mode.

Namespace : DevExpress.XtraPivotGrid

Assembly : DevExpress.XtraPivotGrid.v25.2.dll

NuGet Package : DevExpress.Win.PivotGrid

Declaration

• C#
• VB.NET

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

<XtraSerializableProperty>
<DefaultValue(FieldFilterPopupMode.Default)>
Public Overridable Property FieldFilterPopupMode As FieldFilterPopupMode

Property Value

A FieldFilterPopupMode value that specifies the field’s pop-up filter mode. Default value is interpreted as FieldFilterPopupMode.Excel.

|

Available values:

A default filter popup type.

| | Excel |

An Excel-style filter popup.

| | Classic |

A Classic filter popup.

|

Property Paths

You can access this nested property as listed below:

.Options .FieldFilterPopupMode

|

Remarks

The Pivot Grid supports Excel-style and Classic pop-up filters. For more information, see Pop-up Filter.

You can specify the pop-up filter style at three levels:

1. Application level

2. Control level

• C#
• VB.NET

pivotGridControl.OptionsFilterPopup.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

pivotGridControl.OptionsFilterPopup.FieldFilterPopupMode = FieldFilterPopupMode.Excel

This control level setting overrides the WindowsFormsSettings.ColumnFilterPopupMode global setting.

1. Field level

• C#
• VB.NET

fieldTrademark.Options.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

fieldTrademark.Options.FieldFilterPopupMode = FieldFilterPopupMode.Excel

The field level setting overrides the control level settings.

You cannot use the Excel-style filter in the following cases:

• the datasource type is OLAP;
• the PivotGridControl.CustomFilterPopupItems event is handled.

See Also

PivotGridFieldOptionsEx Class

PivotGridFieldOptionsEx Members

DevExpress.XtraPivotGrid Namespace