Click or drag to resize

AutoFilterByDynamic Method

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

DynamicFilter filters by a dynamic criteria that can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today").

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 43.0.35.1020
Syntax
public AutoFilter ByDynamic(
	int columnIndex,
	DynamicFilterType dynamicFilterType
)

Parameters

columnIndex
Type: SystemInt32
The index of a column relative to the Range that a set DynamicFilter applies to.
dynamicFilterType
Type: GemBox.SpreadsheetDynamicFilterType
The dynamic filter type.

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.
Remarks
If FilterColumn already specifies a filter (Filter is not equal to ), it will be overridden.
See Also