OptionsColumnFilter.FilterPopupMode Property
Gets or sets which filtering options are available in pop-up menus and how they are presented.
Namespace: DevExpress.XtraGrid.Columns
Assembly: DevExpress.XtraGrid.v24.1.dll
NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation
#Declaration
[DefaultValue(FilterPopupMode.Default)]
[XtraSerializableProperty]
public virtual FilterPopupMode FilterPopupMode { get; set; }
#Property Value
Type | Default | Description |
---|---|---|
Filter |
Default | A Filter |
Available values:
Name | Description |
---|---|
Default | The actual display mode is determined by the View’s Options If the View’s Options
If the View’s Options
If the Windows
|
List | The filter dropdown is represented as a regular list of filter items. Clicking an item invokes a corresponding action, and automatically closes the dropdown. |
Checked |
The filter dropdown is represented as a checked list of filter items. In this mode, an end-user can select more than one item simultaneously. When the dropdown window is closed by clicking the OK button, the View will display those records that contain the checked values: |
Date | This mode is equivalent to Date |
Date |
The filter dropdown contains a built-in calendar plus check boxes to select common non-intersecting date intervals. The available date intervals include:
If there is no underlying data for the specified date range, the corresponding check box is hidden. If all values in the date-time column are set to null, all check boxes are visible. The built-in calendar allows a user to select a specific date or a date range. To allow the selection of two or more individual dates, switch to |
Date |
This mode is equivalent to Date
|
Excel | The tabbed UI, inspired by MS Excel, that displays column values and provides filtering options most suitable for the column’s data type. |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Filter |
---|---|
Grid |
|
#Remarks
Use the following properties to specify the filter menu mode:
- for the entire application - the static WindowsFormsSettings.ColumnFilterPopupMode property.
- for a specific control = the ColumnView.OptionsFilter.ColumnFilterPopupMode property. This setting overrides the static WindowsFormsSettings.ColumnFilterPopupMode property.
- for a specific column - the
GridColumn.OptionsFilter.FilterPopupMode
property. This setting overrides theColumnView.OptionsFilter.ColumnFilterPopupMode
property.
using DevExpress.XtraEditors;
WindowsFormsSettings.ColumnFilterPopupMode = DevExpress.XtraEditors.ColumnFilterPopupMode.Classic;
gridView1.OptionsFilter.ColumnFilterPopupMode = DevExpress.XtraGrid.Columns.ColumnFilterPopupMode.Excel;
colAddress.OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.CheckedList;
colDate.OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.Date;
Note
If you handle events from the list below, Data Grid switches from Excel-style filters to classic filtering menus. In this case, set the Grid
property to Excel to use Excel-style filters.