ApplyCustomFilter(Int32,CustomFilterCondition) Method

Applies a CustomFilter to the column.

Syntax

C#

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

Exception	Description
System.ArgumentNullException	condition is null.
System.InvalidOperationException	If the Region was not set.
System.ArgumentOutOfRangeException	If 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: Android 4.4+, iOS 8+

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