Skip to main content

PivotGridFieldOptionsEx.FieldFilterPopupMode Property

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

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

Property Value

Type Default Description
FieldFilterPopupMode Default

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

Available values:

Name Description
Default

A default filter popup type.

Excel

An Excel-style filter popup.

WinPivot_Filtering_Excel

Classic

A Classic filter popup.

WinPivot_Filtering_Classic

Property Paths

You can access this nested property as listed below:

Object Type Path to FieldFilterPopupMode
PivotGridField
.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

    Use the WindowsFormsSettings.ColumnFilterPopupMode static option for all controls in your application.

  2. Control level

    Use the PivotGridOptionsFilterPopup.FieldFilterPopupMode property to specify a pop-up filter’s type for the entire PivotGridControl.

pivotGridControl.OptionsFilterPopup.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

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

  1. Field level

    Use the PivotGridFieldOptionsEx.FieldFilterPopupMode property to define a pop-up filter for a specific field.

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:

See Also