VGridControl.ShowFilterPopupExcel Event

Allows you to hide specific filter conditions from the ‘Filters’ tab of the Excel-style Filter Dropdown.

Namespace: DevExpress.XtraVerticalGrid

Assembly: DevExpress.XtraVerticalGrid.v19.1.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.XtraVerticalGrid.FilterPopupExcelEventArgs.

Remarks

The ShowFilterPopupExcel event allows you to hide specific predefined conditions from the ‘Filters’ tab of the Excel-style Filter Dropdown. For instance, by default, the ‘Filters’ tab contains the ‘Is Blank’ and ‘Is Not Blank’ filter conditions. See the figure below.

The following code illustrates how to hide these conditions from the ‘Filters’ tab.

C#

private void vGridControl1_ShowFilterPopupExcel(object sender, DevExpress.XtraVerticalGrid.FilterPopupExcelEventArgs e) {
    e.ShowBlanks = false;
}

VB.NET

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

See the result below.

Instead of handling the ShowFilterPopupExcel event, you can also use related static properties accessible through the DevExpress.Utils.Filtering.ExcelFilterOptions.Default static (Shared in VB) field. By doing so, you can hide specific filtering conditions for all Excel-inspired filter dropdowns for all controls in the application.

C#

ExcelFilterOptions.Default.ShowNulls = false;

VB.NET

ExcelFilterOptions.Default.ShowNulls = False