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.v25.2.dll

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

csharp

[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

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.