IXlsSortCondition
COM interface ( getting help with interfaces )

 

interface IXlsSortCondition : IDispatch
{
  [id(1),propput] HRESULT ColumnIndex([in]int columnindex);
  [id(1),propget] HRESULT ColumnIndex([out, retval]int* columnindex);
  [id(2),propput] HRESULT SortOnWhat([in]enumSortCondition sortOn);
  [id(2),propget] HRESULT SortOnWhat([out, retval]enumSortCondition* sortOn);
  [id(3),propput] HRESULT CustomList([in]IXlsList* list);
  [id(4),propput] HRESULT SortColor([in]int rgb);
  [id(5),propput] HRESULT SortIconset([in]enumIconSet ics);
  [id(6),propput] HRESULT SortIconsetIndex([in]int nCustomIconIndex);
  [id(7),propput] HRESULT Ascending([in]BOOL bAscending);
  [id(7),propget] HRESULT Ascending([out, retval]BOOL* bAscending);
}

 

HRESULT ColumnIndex([in]int columnindex);
defines the column to be sorted. Starts at 1.

HRESULT ColumnIndex([out, retval]int* columnindex);
returns the column to be sorted. Starts at 1.

HRESULT SortOnWhat([in]enumSortCondition sortOn);
defines how sort should be based on. Default is : values

HRESULT SortOnWhat([out, retval]enumSortCondition* sortOn);
returns how sort should be based on. Default is : values

HRESULT CustomList([in]IXlsList* list);
sets the custom list for sorting. Applies to sorting on values.

HRESULT SortColor([in]int rgb);
sets the color used for sorting. Applies to sorting on cell background color and font color.

HRESULT SortIconset([in]enumIconSet ics);
sets the icon set used for sorting. Applies to sorting on icons.

HRESULT SortIconsetIndex([in]int nCustomIconIndex);
sets the custom icon index used for sorting. Applies to sorting on icons. Starts at 1.

HRESULT Ascending([in]BOOL bAscending);
sets whether the sort is ascending, i.e. a, b, c, ... Only makes sense for sorting on values

HRESULT Ascending([out, retval]BOOL* bAscending);
retrieves whether the sort is ascending, i.e. a, b, c, ... Only makes sense for sorting on values