ExcelColumnFilterSettings.DefaultRulesFilterType Property

Gets or sets the default clause type in the Filter Rules tab.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v24.1.Core.dll

NuGet Package: DevExpress.Wpf.Grid.Core

Declaration

C#

public ClauseType? DefaultRulesFilterType { get; set; }

VB.NET

Public Property DefaultRulesFilterType As ClauseType?

Property Value

Type	Description
Nullable<ClauseType>	ClauseType

Available values:

Show 38 items

Name	Description
Equals	Specifies the Equals filter criteria.
DoesNotEqual	Specifies the Does Not Equal filter criteria.
Greater	Specifies the Greater filter criteria.
GreaterOrEqual	Specifies the Greater Or Equal filter criteria.
Less	Specifies the Less filter criteria.
LessOrEqual	Specifies the Less Or Equal filter criteria.
InRange
NotInRange
Between	Specifies the Between filter criteria.
NotBetween	Specifies the Not Between filter criteria.
Contains	Specifies the Contains filter criteria.
DoesNotContain	Specifies the Does Not Contain filter criteria.
BeginsWith	Specifies the Begins With filter criteria.
EndsWith	Specifies the Ends With filter criteria.
Like	Specifies the Like filter criteria.
NotLike	Specifies the Not Like filter criteria.
IsNull	Specifies the Is Null filter criteria.
IsNotNull	Specifies the Is Not Null filter criteria.
AnyOf	Specifies the Any Of filter criteria.
NoneOf	Specifies the None Of filter criteria.
IsNullOrEmpty	Specifies the Is Null Or Empty filter criteria.
IsNotNullOrEmpty	Specifies the Is Not Null Or Empty filter criteria.
InDateRange
NotInDateRange
IsBeyondThisYear	Specifies the Is Beyond This Year filter criteria.
IsLaterThisYear	Specifies the Is Later This Year filter criteria.
IsLaterThisMonth	Specifies the Is Later This Month filter criteria.
IsNextWeek	Specifies the Is Next Week filter criteria.
IsLaterThisWeek	Specifies the Is Later This Week filter criteria.
IsTomorrow	Specifies the Is Tomorrow filter criteria.
IsToday	Specifies the Is Today filter criteria.
IsYesterday	Specifies the Is Yesterday filter criteria.
IsEarlierThisWeek	Specifies the Is Earlier This Week filter criteria.
IsLastWeek	Specifies the Is Last Week filter criteria.
IsEarlierThisMonth	Specifies the Is Earlier This Month filter criteria.
IsEarlierThisYear	Specifies the Is Earlier This Year filter criteria.
IsPriorThisYear	Specifies the Is Prior This Year filter criteria.
Function

Property Paths

You can access this nested property as listed below:

Object Type	Path to DefaultRulesFilterType
FilterPopupEventArgs	.ExcelColumnFilterSettings .DefaultRulesFilterType