ExcelFilterOptions.ShowComparisons Property

Gets or sets whether to display comparison filters in Excel-style filter popup menus.

Namespace: DevExpress.Utils.Filtering

Assembly: DevExpress.Data.v25.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

public bool? ShowComparisons { get; set; }

VB.NET

Public Property ShowComparisons As Boolean?

Property Value

Type	Description
Nullable<Boolean>	true to enable comparison operators (for example, greater than and less than); otherwise false.

Remarks

The following code snippet configures global Excel-style filter behavior:

using DevExpress.Utils.Filtering;

// Set the default filter type for all data types:
ExcelFilterOptions.Default.DefaultFilterType = CustomUIFilterType.GreaterThan;

// Set the default filter type for date values:
ExcelFilterOptions.Default.DefaultDateFilterType = CustomUIFilterType.ThisMonth;

// Set the default filter type for time values:
ExcelFilterOptions.Default.DefaultTimeFilterType = CustomUIFilterType.ThisHour;

// Set the default filter type for text values:
ExcelFilterOptions.Default.DefaultTextFilterType = CustomUIFilterType.Contains;

// Enable comparison operators:
ExcelFilterOptions.Default.ShowComparisons = true;

// Enable condition-based filters:
ExcelFilterOptions.Default.ShowConditionalFilters = true;

// Disable custom (user-defined) filter expressions:
ExcelFilterOptions.Default.ShowCustomFilters = false;

// Set the 'Filters' tab as the default tab in Excel-style filter popups:
ExcelFilterOptions.Default.PreferredTabType = ExcelFilterOptions.TabType.Filters;