IXlsAutoFilter

COM interface ( getting help with interfaces )

interface IXlsAutoFilter : IDispatch
{
  [id(1), propget] HRESULT CustomFilter([in]int columnIndex, [out,retval]IXlsCustomFilter** customFilter);
  [id(2)         ] HRESULT Apply();
  [id(3)         ] HRESULT Delete();
  [id(4), propget] HRESULT Sort([out,retval]IXlsSort** sort);

}

HRESULT CustomFilter([in]int columnIndex, [out,retval]IXlsCustomFilter** customFilter);
returns the custom filter for the passed column index. The column index is 1-based.

HRESULT Apply();
applies all filters of the auto-filter. Whenever a custom filter is added, it is automatically applied.

HRESULT Delete();
deletes auto-filters.

HRESULTSort([out,retval]IXlsSort** sort);
returns the sort filter.