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

OptionsColumnFilter.PopupExcelFilterEnumFilters Property

Gets or sets whether to show relational operators (equality and inequalities) in the Filters tab of the Excel-style Filter Dropdown (if the current column contains enumeration data).

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v24.2.dll

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

#Declaration

[DefaultValue(ExcelFilterEnumFilters.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterEnumFilters PopupExcelFilterEnumFilters { get; set; }

#Property Value

Type Default Description
DevExpress.XtraGrid.Columns.ExcelFilterEnumFilters Default

A DevExpress.XtraGrid.Columns.ExcelFilterEnumFilters enumeration value that specifies whether to show relational operators (equality and inequalities) used to create a filter condition in the Filters tab of the Excel-style Filter Dropdown. By Default, the Filters tab is hidden.

#Property Paths

You can access this nested property as listed below:

Object Type Path to PopupExcelFilterEnumFilters
GridColumn
.OptionsFilter .PopupExcelFilterEnumFilters

#Remarks

By default, for enumeration value columns, the predefined filters are not shown in the Excel-style Filter Dropdown. Set the PopupExcelFilterEnumFilters property to EqualityFilters to show the equality relational operators (Equals, DoesNotEqual). To show also the inequality operators (GreaterThan, GreaterThanOrEqualTo, LessThan, LessThanOrEqualTo, Between), set the PopupExcelFilterEnumFilters property to AllFilters.

See Also