ApplyCustomFilter(CustomFilterCondition,CustomFilterCondition,ConditionalOperator) Method

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

Syntax

C#

public CustomFilter ApplyCustomFilter( 
   CustomFilterCondition condition1,
   CustomFilterCondition condition2,
   ConditionalOperator conditionalOperator
)

Parameters

condition1

The first condition used to filter the data.

condition2

The second condition used to filter the data.

conditionalOperator

The operator which defines how to logically combine condition1 and condition2.

Exceptions

Exception	Description
System.ArgumentNullException	condition1 is null.
Infragistics.Documents.Excel.MockClasses.InvalidEnumArgumentException	conditionalOperator is not defined in the Infragistics.Documents.Excel.Filtering.ConditionalOperator 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.

Remarks

If condition2 is null, the conditionalOperator value is irrelevant.

Note: If one of the filter condition values is longer than 255 characters in length and the workbook is saved in one of the 2003 formats, the correct rows will be hidden in the saved file, but the filter will be missing from the column.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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