Skip to main content

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