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.v23.2.dll
NuGet Packages: DevExpress.Win.Navigation, DevExpress.Win.TreeList
Declaration
Event Data
The ShowFilterPopupExcel event's data class is DevExpress.XtraTreeList.FilterPopupExcelEventArgs.
Remarks
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.
This API affects Excel-styled filter dropdown menus only. To enable these menus, set the TreeListOptionsColumnFilter.FilterPopupMode to FilterPopupMode.Excel.