Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotGridFieldOptionsEx.FieldFilterPopupMode Property

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.2.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