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

#Declaration

[DefaultValue(ExcelFilterTextFilters.Default)]
[XtraSerializableProperty]
public virtual ExcelFilterTextFilters PopupExcelFilterTextFilters { get; set; }

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

See Also