TreeList.FilterPopupExcelData Event
Allows you to remove and modify items in the Excel-style Filter Dropdown, as well as add your own custom items that apply specific filtering conditions.
Namespace: DevExpress.XtraTreeList
Assembly: DevExpress.XtraTreeList.v19.1.dll
Declaration
[DXCategory("Behavior")]
public event FilterPopupExcelDataEventHandler FilterPopupExcelData
Event Data
The FilterPopupExcelData event's data class is DevExpress.XtraTreeList.FilterPopupExcelDataEventArgs.
Remarks
The code snippet below removes multiple default items from Excel-styled dropdowns and adds two custom filtering items.
void treeList1_FilterPopupExcelData(object sender, FilterPopupExcelDataEventArgs e) {
// Data Items
e.ChangeText(null, "Nil");
e.DataItems.RemoveRange(5, e.DataItems.Count - 5);
if(e.Column == treeList1.Columns["Name"])
e.AddData("AB", "AB");
// Predefined Filters
e.AddFilter("First Filter", e.Column.FieldName + " Is Null");
e.AddFilter("Second Filter", e.Column.FieldName + " Is Not Null");
}
To enable Excel-styled filtering dropdown menus, set the TreeListOptionsColumnFilter.FilterPopupMode to FilterPopupMode.Excel.
See Also