Click or drag to resize

AutoFilterByCustom Method (Int32, FilterOperator, Object)

Sets a CustomFilter to a column with the specified index (relative to the Range).

CustomFilter filters by a one or two conditions (operators and values).

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 43.0.35.1020
Syntax
public AutoFilter ByCustom(
	int columnIndex,
	FilterOperator operator,
	Object value
)

Parameters

columnIndex
Type: SystemInt32
The index of a column relative to the Range that a set Top10Filter applies to.
operator
Type: GemBox.SpreadsheetFilterOperator
The operator used by the filter condition.
value
Type: SystemObject
The value used by the filter condition.

Return Value

Type: AutoFilter
This AutoFilter to specify additional filters or to apply filter.
Exceptions
ExceptionCondition
ArgumentOutOfRangeExceptioncolumnIndex is less than zero or is equal to or greater than Width of the Range.
NotSupportedExceptionValue's type is not supported.
Remarks
If FilterColumn already specifies a filter (Filter is not equal to ), it will be overridden.
See Also