Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TreeList.ShowFilterPopupExcel Event

Allows you to hide specific filter conditions from the Filters tab of the Excel-style Drop-down Filter.

Namespace: DevExpress.XtraTreeList

Assembly: DevExpress.XtraTreeList.v24.2.dll

NuGet Packages: DevExpress.Win.Navigation, DevExpress.Win.TreeList

#Declaration

[DXCategory("Behavior")]
public event FilterPopupExcelEventHandler ShowFilterPopupExcel

#Event Data

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

#Remarks

The following code hides Null and Not Null filter conditions:

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

The e.HideFilter method allows you to hide specific conditions.

Instead of the ShowFilterPopupExcel event, you can also use related static properties accessible through the DevExpress.Utils.Filtering.ExcelFilterOptions.Default field. These properties allow you to hide filter conditions for all Tree List controls in the application:

ExcelFilterOptions.Default.ShowNulls = false;
See Also