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.v20.1.dll

Declaration

[DXCategory("Behavior")]
public event FilterPopupExcelEventHandler ShowFilterPopupExcel
<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.

VGridControl_ShowFilterPopupExcel_Event

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


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

See the result below.

VGridControl_ShowFilterPopupExcel_Event_HideBlanks

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.


ExcelFilterOptions.Default.ShowNulls = false;
See Also