TreeList.ShowFilterPopupExcel Event

Allows you to hide specific filtering conditions from the "Filters" tab of the Excel-style Filter Dropdown.

Namespace: DevExpress.XtraTreeList

Assembly: DevExpress.XtraTreeList.v20.1.dll


public event FilterPopupExcelEventHandler ShowFilterPopupExcel
Public Event ShowFilterPopupExcel As FilterPopupExcelEventHandler

Event Data

The ShowFilterPopupExcel event's data class is DevExpress.XtraTreeList.FilterPopupExcelEventArgs.


The following code illustrates how to hide the "Null" and "Not Null" filtering conditions.

void treeList1_ShowFilterPopupExcel(object sender, FilterPopupExcelEventArgs e) {
    e.ShowNulls = false;

Instead of handling the ShowFilterPopupExcel event, you can also use related static properties accessible through the DevExpress.Utils.Filtering.ExcelFilterOptions.Default field. By doing so, you can hide specific filtering conditions for all Tree Lists at once.

ExcelFilterOptions.Default.ShowNulls = false;

This API affects Excel-styled filter dropdown menus only. To enable these menus, set the TreeListOptionsColumnFilter.FilterPopupMode to FilterPopupMode.Excel.

See Also