Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [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
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Collapse]Tree List
   [Expand]Product Information
   [Expand]Feature Center
   [Collapse]Visual Elements
     Automatic Filtering Row
     Blank Column
     Caption Panel
     Cell
     Column
     Column Button
     Column Header
     Column Header Context Menu
     Column Header Panel
     Column's Filter DropDown
     Column's Filter DropDown: Excel Style
     Customization Form
     Empty Area
     Expand Button
     Filter Button
     Filter Editor
     Filter Panel
     Find Panel
     Fixed Line
     Footer Cell
     Footer Context Menu
     Group Footer
     Node Image
     Node Indents
     Node Indicator Panel
     Preview Section
     Summary Footer
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End User Capabilities
   [Expand]Member Tables
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [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]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Column's 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 Column's Filter DropDown 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 suitable for the 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 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 the list of supported data types and UI examples:

Expanded Invoke Filter Dropdown

An end-user can invoke the Filter DropDown by clicking the column's Filter Button .

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 TreeList controls in your application.

  2. Control level

    A TreeList's TreeListOptionsFilter.ColumnFilterPopupMode property (TreeList.OptionsFilter.ColumnFilterPopupMode) specifies the default column Filter DropDown style in a specific control. This setting overrides the WindowsFormsSettings.ColumnFilterPopupMode global setting.

  3. Column level

    A column's TreeListOptionsColumnFilter.FilterPopupMode property (TreeListColumn.OptionsFilter.FilterPopupMode) specifies the Filter DropDown style for a specific column. This setting overrides the TreeList.OptionsFilter.ColumnFilterPopupMode setting.

Expanded Filter Dropdown Options

Below you can see the list of options that affect the Excel style Filter DropDown behavior:

Expanded See Also

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