Skip to main content

ExcelColumnFilterSettings.DefaultRulesFilterType Property

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

Namespace: DevExpress.Xpf.Grid

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

NuGet Package: DevExpress.Wpf.Grid.Core

Declaration

public ClauseType? DefaultRulesFilterType { get; set; }

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
See Also