VGridControl.ShowFilterPopupExcel Event

Allows you to hide specific filter conditions from the Filters tab of the Excel-style Drop-down Filter.

Namespace : DevExpress.XtraVerticalGrid

Assembly : DevExpress.XtraVerticalGrid.v25.2.dll

NuGet Packages : DevExpress.Win.Navigation, DevExpress.Win.VerticalGrid

csharp

[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 drop-down filter. For instance, this tab contains the Is Blank and Is Not Blank filter conditions:

The following code hides these conditions from the Filters tab:

C#
VB.NET

csharp

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

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

The e.HideFilter method allows you to hide specific conditions.

Instead of the ShowFilterPopupExcel event, you can also use related static properties accessible through the DevExpress.Utils.Filtering.ExcelFilterOptions.Default field. These properties allow you to hide filter conditions for all controls in the application:

C#
VB.NET

csharp

ExcelFilterOptions.Default.ShowNulls = false;

ExcelFilterOptions.Default.ShowNulls = False