ApplyCustomFilter(Int32,CustomFilterCondition,CustomFilterCondition,ConditionalOperator) Method

'Declaration
 
Public Overloads Function ApplyCustomFilter( _
   ByVal relativeColumnIndex As Integer, _
   ByVal condition1 As CustomFilterCondition, _
   ByVal condition2 As CustomFilterCondition, _
   ByVal conditionalOperator As ConditionalOperator _
) As CustomFilter

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

Parameters

relativeColumnIndex

A zero based column index relative to the Region

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.

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.

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

WorksheetFilterSettings Class
WorksheetFilterSettings Members
Overload List
CustomFilter Class
GetFilter Method
ClearFilter Method