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

Declaration

[DefaultValue(ExcelFilterEnumFilters.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterEnumFilters PopupExcelFilterEnumFilters { get; set; }
<DefaultValue(ExcelFilterEnumFilters.Default)>
<XtraSerializableProperty>
Public Overridable Property PopupExcelFilterEnumFilters As ExcelFilterEnumFilters

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
LayoutViewColumn
.OptionsFilter.PopupExcelFilterEnumFilters
BandedGridColumn
.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