ExcelFilterOptions.Default Field

The default configuration for Excel-style filter popup menus.

Namespace: DevExpress.Utils.Filtering

Assembly: DevExpress.Data.v25.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

public static readonly ExcelFilterOptions Default

VB.NET

Public Shared ReadOnly Default As ExcelFilterOptions

Field Value

Type	Description
ExcelFilterOptions	A baseline configuration.

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;