Version

ApplyCustomFilter(Int32,CustomFilterCondition) Method

Applies a CustomFilter to the column.
Syntax
'Declaration
 
Public Overloads Function ApplyCustomFilter( _
   ByVal relativeColumnIndex As Integer, _
   ByVal condition As CustomFilterCondition _
) As CustomFilter
public CustomFilter ApplyCustomFilter( 
   int relativeColumnIndex,
   CustomFilterCondition condition
)

Parameters

relativeColumnIndex
A zero based column index relative to the Region
condition
The condition which must pass for the data to be filtered in.
Exceptions
ExceptionDescription
System.ArgumentNullExceptioncondition is null.
System.InvalidOperationExceptionIf the Region was not set.
System.ArgumentOutOfRangeExceptionIf the relativeColumnIndex is outside of the Region.
Remarks

Note: If the filter condition value 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: 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

See Also