GrapeCity.Documents.Excel.IAutoFilter

Interface IAutoFilter

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents autofiltering for the specified worksheet.

public interface IAutoFilter

Properties

FilterMode

Returns True if the worksheet is in the AutoFilter filter mode (read-only).

bool FilterMode { get; }

Property Value

bool

Filters

Returns a Filters collection that represents all the filters in an autofiltered range (read-only).

IFilters Filters { get; }

Property Value

IFilters

Range

Returns a Range object that represents the range to which the specified AutoFilter applies.

IRange Range { get; }

Property Value

IRange

Sort

Gets the sort column or columns, and sort order for the AutoFilter collection.

ISort Sort { get; }

Property Value

ISort

Methods

ApplyFilter()

Applies the specified AutoFilter object.

void ApplyFilter()

ShowAllData()

Displays all the data returned by the AutoFilter object.

void ShowAllData()