PivotGridControl.ShowFilterPopupExcel Event

Allows you to customize the Excel-style filter popup (for instance, to hide specific filtering conditions from the "Filters" tab).

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.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 FilterPopupExcelEventArgs. The following properties provide information specific to this event:

Property Description
DefaultFilterType Gets or sets the filter operator selected by default in the Filters tab.
Field Get the Pivot Grid field being processed.
IsRadioMode Gets or sets whether single (the radio mode) or multiple filter values can be selected simultaneously.
ShowAggregates For internal use.
ShowBlanks Gets or sets whether or not to show the 'Is Blank' and 'Is Not Blank' filter conditions.
ShowComparisons Gets or sets whether or not to show comparison filter conditions (Greater Than, Less Than, etc.).
ShowCustomFilters Gets or sets whether or not to show the 'Custom Filter'.
ShowFiltersTab Gets or sets whether or not to show the Filters tab.
ShowLikeFilters
ShowNulls Gets or sets whether or not to show the 'Is Null' and 'Is Not Null' filter conditions.
ShowPredefinedFilters Gets or sets whether or not to show the 'Predefined Filters'.
ShowSequences For internal use.

Remarks

The ShowFilterPopupExcel event allows you to customize the Excel-style filter popup in various ways. For instance, you can use the FilterPopupExcelEventArgs.IsRadioMode event parameter to disable multiselection. Other event parameters (such as FilterPopupExcelEventArgs.ShowNulls, FilterPopupExcelEventArgs.ShowBlanks) allows you to hide specific filtering conditions from the "Filters" tab.

Examples

The code snippet below shows how to enable the radio mode in the Excel-style filter popup by handling the PivotGridControl.ShowFilterPopupExcel event. In this example, FilterPopupExcelEventArgs.IsRadioMode event parameter is set to true to disable multiselection for the 'fieldTrademark' field .

IsRadioMode = false IsRadioMode = true
WinPivot_Filtering_Excel WinPivot_Filtering_Excel_RadioMode
private void PivotGridControl_ShowFilterPopupExcel(object sender, FilterPopupExcelEventArgs e) {
    if (e.Field == fieldTrademark) {
        e.IsRadioMode = true;
    }
}
See Also