CustomFilterCondition Constructor(ExcelComparisonOperator,String)

Creates a new CustomFilterCondition instance.

Syntax

Visual Basic

'Declaration
 
Public Function New( _
   ByVal comparisonOperator As ExcelComparisonOperator, _
   ByVal value As String _
)

C#

public CustomFilterCondition( 
   ExcelComparisonOperator comparisonOperator,
   string value
)

Parameters

comparisonOperator

The operator which describes how the cell values should be compared against value.

value

The string against which the cell values should be compared. The string can contains wild cards for any character (?) or for zero or more characters (*).

Exceptions

Exception	Description
System.ComponentModel.InvalidEnumArgumentException	comparisonOperator is not defined in the ExcelComparisonOperator enumeration.

Remarks

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