OptionsColumnFilter.PopupExcelFilterTextFilters Property

Gets or sets whether to show pattern-matching (e.g., Is Like) and relational (e.g., Greater Than) operators for string values in the Excel style pop-up filter menus.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v20.1.dll

Declaration

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

Property Value

Type Default Description
DevExpress.XtraGrid.Columns.ExcelFilterTextFilters

Default

AllFilters, to show relational and pattern-matching operators in the Excel style pop-up filter menus; otherwise, TextFilters or Default.

Property Paths

You can access this nested property as listed below:

Object Type Path to PopupExcelFilterTextFilters
GridColumn
.OptionsFilter.PopupExcelFilterTextFilters
LayoutViewColumn
.OptionsFilter.PopupExcelFilterTextFilters
BandedGridColumn
.OptionsFilter.PopupExcelFilterTextFilters

Remarks

The PopupExcelFilterTextFilters property specifies filters and operators the Excel style pop-up filter menus contain.

  • TextFilters or Default — the menus contain only operators and filters for text values (Equals, Does Not Equal, Begins With, Ends With, Contains, Does Not Contain, Is Blank, Is Not Blank, Custom Filter);
  • AllFilters — the menus also contain pattern-matching (Is Like, Is Not Like) and relational (Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To, Between) operators.

The ColumnView.ShowFilterPopupExcel event allows you to also specify the FilterPopupExcelEventArgs.ShowLikeFilters and FilterPopupExcelEventArgs.ShowComparisons arguments to show/hide the pattern-matching and relational operators.

See Also