Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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

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

#Declaration

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

#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:

VGridControl_ShowFilterPopupExcel_Event

The following code hides these conditions from the Filters tab:

VGridControl_ShowFilterPopupExcel_Event_HideBlanks

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

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:

ExcelFilterOptions.Default.ShowNulls = false;
See Also