Column Pop-up Filter Menus

Users can click the filter button in a column header to invoke a pop-up filter menu.

Column Filter Dropdown

Pop-up filter menus can be displayed in the following styles:

  • Excel style — provides value lists and data-specific filters.

    TreeList_ExcelFilterDropdown

  • Classic style — a calendar (for date-time values), a value list, or a checked value list (for other data types).

    Dropdown Filter Lists

The table below lists the main properties that affect element appearance:

Availability

TreeListOptionsCustomization.AllowFilter

TreeListOptionsColumnFilter.AllowFilter

Filter Mode

TreeListOptionsFilter.FilterMode

Filter by Edit Value or Display Text

TreeListColumn.FilterMode

Display Mode

WindowsFormsSettings.ColumnFilterPopupMode

TreeListOptionsFilter.ColumnFilterPopupMode

TreeListOptionsColumnFilter.FilterPopupMode

Immediate Updates (for date-time columns)

TreeListOptionsColumnFilter.ImmediateUpdatePopupDateFilter

Contents

The TreeListColumn.FilterMode property specifies whether the filter menu contains unique edit values or display values.

The TreeList.OptionsFilter.ShowAllValuesInFilterPopup property specifies whether the filter menus contain unique values from all the records in a control's data source or only from those records that meet the current filter criteria.

Handle the TreeList.ShowFilterPopupListBox event to dynamically change filter lists. Handle the TreeList.ShowFilterPopupCheckedListBox event to customize checked filter lists.

MRU Items

TreeList.OptionsFilter.AllowColumnMRUFilterList

TreeList.OptionsFilter.MRUColumnFilterListCount

Height

The TreeListOptionsFilter.ColumnFilterPopupRowCount property specifies the maximum number of items in the regular filter lists.

Look And Feel

TreeList.LookAndFeel

See Also