CellRange.AutoFilter Method (Int32, Object, AutoFilterOperator, Object, Boolean)

Enables autofiltering for the specified column in this range using the specified criteria.

Namespace: MindFusion.Spreadsheet.Wpf
Assembly: MindFusion.Spreadsheet.Wpf

 Syntax

C#

public void AutoFilter (
    int field,
    Object criteria1,
    AutoFilterOperator op,
    Object criteria2,
    bool visibleDropDown
)

Visual Basic

Public Sub AutoFilter( _
    field As Integer, _
    criteria1 As Object, _
    op As AutoFilterOperator, _
    criteria2 As Object, _
    visibleDropDown As Boolean _
)

 Parameters

field

The 1-based index of the column, relatively to the leftmost column in the range.

criteria1

A string or an array of values, specifying the first criteria, for example "101". Use "=" to find blank fields, or use "<>" to find nonblank fields. If this argument is omitted, the criteria is All. If op is Top10Items, criteria1 specifies the number of items, for example, "10".

op

A value specifying the type of the filter.

criteria2

The second criteria. Used with criteria1 and op to construct compound criteria.

visibleDropDown

true to display the autofilter drop-down arrow for the filtered field; false to hide the autofilter drop-down arrow for the filtered field.