WindowsFormsSettings.ColumnFilterPopupMode Property

Gets or sets the default display mode of column filter dropdowns in all GridControls, TreeLists and PivotGridControls in the current application.

Namespace: DevExpress.XtraEditors

Assembly: DevExpress.Utils.v19.1.dll

Declaration

C#

public static ColumnFilterPopupMode ColumnFilterPopupMode { get; set; }

VB.NET

Public Shared Property ColumnFilterPopupMode As ColumnFilterPopupMode

Property Value

Type	Description
ColumnFilterPopupMode	A value that specifies the default display mode of column filter dropdowns in all GridControls and TreeLists in the current application.

Available values:

Name	Description
Default	Equivalent to the ColumnFilterPopupMode.Excel setting.
Excel	Grid and TreeList columns display Excel-style filter menus.
Classic	Grid and TreeList columns display classic drop-down filter menus.

Remarks

Column filter dropdowns (within the GridConrol and within the TreeList) can be presented using the following display modes (the first two modes are also called classic):

• Regular list,
• Calendar (for date-time columns) — a window with an embedded calendar along with predefined filter items for quick selection of common date intervals,
• Checked list,
• MS Excel-inspired style.

The style of column filter dropdowns can be set at three levels.

1. Application level.

   The current static WindowsFormsSettings.ColumnFilterPopupMode property specifies the default column filter dropdown style for all GridControls and TreeLists in your application.

2. Control level.

   For the GridControl, use a View’s ColumnViewOptionsFilter.ColumnFilterPopupMode property (ColumnView.OptionsFilter.ColumnFilterPopupMode) to specify the default column filter dropdown style in this specific View.

   For the TreeList control, use the TreeListOptionsFilter.ColumnFilterPopupMode property (TreeList.OptionsFilter.ColumnFilterPopupMode).

   These control level settings override the WindowsFormsSettings.ColumnFilterPopupMode global setting for the current control.

3. Column level.

   For the GridControl, use a column’s OptionsColumnFilter.FilterPopupMode property (GridColumn.OptionsFilter.FilterPopupMode) to specify the filter dropdown style for this specific column.

   For the TreeList control, use a column’s TreeListOptionsColumnFilter.FilterPopupMode property (TreeListColumn.OptionsFilter.FilterPopupMode).

   The column level settings override the corresponding control level settings for the current column.

The WindowsFormsSettings.ColumnFilterPopupMode property can be set to one of the following values:

• Default - Enables the Excel mode for the v17 version of DevExpress components and later; for earlier versions, enables the Classic mode (see the Version Compatibility topic to learn about default values of various properties according to the selected DevExpress installation version).

  Note

  The Classic mode is also enabled by default regardless of the selected DevExpress installation version if a custom non-Excel style filter is provided using the following events:

  for the GridControl:

  • ColumnView.ShowFilterPopupCheckedListBox,
  • ColumnView.ShowFilterPopupListBox,
  • ColumnView.ShowFilterPopupDate;

  for the TreeList:

  • TreeList.ShowFilterPopupCheckedListBox,
  • TreeList.ShowFilterPopupListBox,
  • TreeList.ShowFilterPopupDate.
• Classic - Sets classic (regular, checked, or calendar depending on settings or data type) filter dropdown styles as default,
• Excel - Sets the MS Excel-inspired filter dropdown style as default.

For more details on Excel-inspired filter dropdowns, see the GridControl’s Excel Style Filter DropDown and TreeList’s Excel Style Filter DropDown topics.