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.v18.2.dll

Declaration

C#

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

VB.NET

<DXCategory("Behavior")>
Public Event ShowFilterPopupExcel As FilterPopupExcelEventHandler

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.

C#

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

VB.NET

Private Sub treeList1_ShowFilterPopupExcel(ByVal sender As Object, ByVal e As FilterPopupExcelEventArgs)
    e.ShowNulls = False
End Sub

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.

C#

ExcelFilterOptions.Default.ShowNulls = false;

VB.NET

ExcelFilterOptions.Default.ShowNulls = False

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