ApplyRelativeDateRangeFilter Method (WorksheetTableColumn)

Applies a Infragistics.Documents.Excel.Filtering.RelativeDateRangeFilter to the column.

Syntax

C#

public RelativeDateRangeFilter ApplyRelativeDateRangeFilter( 
   RelativeDateRangeOffset offset,
   RelativeDateRangeDuration duration
)

Parameters

offset

The offset of relative filter. This combined with the duration determines the full range of accepted dates.

duration

The duration of the full range of accepted dates.

Exceptions

Exception	Description
Infragistics.Documents.Excel.MockClasses.InvalidEnumArgumentException	offset is not defined in the Infragistics.Documents.Excel.Filtering.RelativeDateRangeOffset enumeration.
Infragistics.Documents.Excel.MockClasses.InvalidEnumArgumentException	duration is not defined in the Infragistics.Documents.Excel.Filtering.RelativeDateRangeDuration enumeration.
System.InvalidOperationException	The WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be applied when the header row or filter button is hidden.
System.InvalidOperationException	If column was removed from the table.

Remarks

The RelativeDateRangeFilter allows you to filter in dates which are in the previous, current, or next time period relative to the date when the filter was applied. The time periods available are day, week, month, quarter, year. So when using the previous filter type with a day duration, a 'yesterday' filter is created. Or when using a current filter type with a year duration, a 'this year' filter is created. However, these filters compare the data against the date when the filter was created. So a 'this year' filter created in 1999 will filter in all cells containing dates in 1999, even if the workbook is opened in 2012.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+