ExcelFilterOptions Properties

Configures Excel-style filter popup behavior across supported DevExpress controls.

Name	Description
DefaultDateFilterType	Gets or sets the default filter type for date values.
DefaultDateTimeOffsetFilterType	Gets or sets the default filter type for DateTimeOffset values.
DefaultFilterType	Gets or sets the default filter type.
DefaultTextFilterType	Gets or sets the default filter type for text.
DefaultTimeFilterType	Gets or sets the default filter type for time values.
PreferredDateTimeValuesTabFilterType	For internal use.
PreferredDateTimeValuesTreeFilterType	For internal use.
PreferredDateValuesTabFilterType	Gets or sets the filter type used to filter DateTime values in Excel-Style Column Filter.
PreferredNumericValuesTabFilterType	Gets or sets the filter type used to filter numeric values in the Excel-Style Column Filter.
PreferredTabType	Gets or sets the preferred (active) filter UI tab in Excel-style filter popup menus.
PreferredTimeValuesTabFilterType	Gets or sets the filter type used to filter TimeOnly values in Excel-Style Column Filter.
ShowAdvancedDatePeriods	Gets or sets whether to display advanced date period filters in Excel-style filter popup menus.
ShowAggregates	Gets or sets whether to display aggregate operators in Excel-style filter popup menus.
ShowBlanks	Gets or sets whether to display blank value filters in Excel-style filter popup menus.
ShowComparisons	Gets or sets whether to display comparison filters in Excel-style filter popup menus.
ShowComparisonsForEnums	Gets or sets whether to display comparison filters for enumerations in Excel-style filter popup menus.
ShowComparisonsForText	Gets or sets whether to display comparison filters for text in Excel-style filter popup menus.
ShowConditionalFilters	Gets or sets whether to display conditional filters in Excel-style filter popup menus.
ShowCustomFilters	Gets or sets whether to display a custom filter UI in Excel-style filter popup menus.
ShowDatePeriods	Gets or sets whether to display standard date period filters in Excel-style filter popup menus.
ShowLikeFilters	Gets or sets whether to display pattern-based filters in Excel-style filter popup menus.
ShowNulls	Gets or sets whether to display null value filters in Excel-style filter popup menus.
ShowPredefinedFilters	Gets or sets whether to display predefined filters in Excel-style filter popup menus.
ShowScrollAnnotations	Gets or sets whether to display scroll annotations.
ShowSequences	Gets or sets whether to display sequence-based filters in Excel-style filter popup menus.
ShowTimePeriods	Gets or sets whether to display time period filters in Excel-style filter popup menus.
UseAnimationForTabs	Controls tab animation.