Log In
[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Grid View
   [Expand]View Technology
   [Expand]Data Editing
   [Collapse]Filtering and Locating Rows
     [Collapse]Filter Dropdowns
       Filter Dropdown: Excel Style
       Filter Dropdown: Regular
       Filter Dropdown: Checked
       Filter Dropdown: Calendar Style
      Filtering Overview
      Filter Settings
      MRU Filters
      Automatic Filtering Row
      Filter Editor
      Custom Filter Dialog
      Filtering in Code
     Locating Rows in Code
     Incremental Search
     Searching via Find Panel
     Tutorial: Incremental Search
     Tutorial: Search/Find Panel
   [Expand]Focus and Selection Handling
   [Expand]Processing Rows
   [Expand]Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
   [Expand]Batch Modifications
   [Expand]Hit Information
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Filter Dropdown: Excel Style

This topic covers the specifics behind the Excel-inspired Filter Dropdown lists. For general information about this and other types of filter dropdowns, refer to the Filter Dropdowns topic.

Expanded Feature Overview

The Filter Dropdown displays in a Microsoft Excel® inspired style by default, which, along with the ability to select custom values, provides predefined filters most suitable for columns' data type. See the animated image below.

Visually, the Excel-inspired filter dropdown consists of two tabs:

  • The Values tab allows an end-user to select particular values or value ranges.
  • The Filters tab displays predefined filter conditions most suitable for the current column's data type. For instance, for date-time columns, it includes Today, Next Week, Last Month, This Year, etc. For numeric columns, it includes Between, Greater Than, etc.

The Excel-inspired Filter Dropdown UI is automatically determined based on the column's data type. Below you can see examples of the different data types:

Expanded Invoke Filter Dropdown

An end-user can invoke the Filter Dropdown by clicking the column's filter button. To open the column's Filter Dropdown in code, call the ColumnView.ShowFilterPopup method.

Expanded Enable Excel-Inspired Filter Dropdown

The Excel-inspired style is enabled by default. However, you can override the default behavior, and specify the style at three levels:

  1. Application level

    The WindowsFormsSettings.ColumnFilterPopupMode static property specifies the default column Filter Dropdown style for all GridControls in your application.

  2. Control level

    A View's ColumnViewOptionsFilter.ColumnFilterPopupMode property (ColumnView.OptionsFilter.ColumnFilterPopupMode) specifies the default column Filter Dropdown style in a certain View. This setting overrides the WindowsFormsSettings.ColumnFilterPopupMode global setting.

  3. Column level

    A column's OptionsColumnFilter.FilterPopupMode property (GridColumn.OptionsFilter.FilterPopupMode) specifies the Filter Dropdown style for a specific column. This setting overrides the ColumnView.OptionsFilter.ColumnFilterPopupMode setting.

Expanded Filter Dropdown Options

Below you can see the list of options that affect the Excel style Filter Dropdown behavior.

In the case of code-first data sources, you can also mark properties with Filtering Attributes to change editors that appear inside an Excel-style filter.

Expanded See Also

How would you rate this topic?​​​​​​​