IXlsSort

COM interface ( getting help with interfaces )

interface IXlsSort : IDispatch
{
  [id(1)] HRESULT PrimaryKey([in]int columnindex, [in]BOOL bAscending);
  [id(2)] HRESULT SecondaryKey([in]int columnindex, [in]BOOL bAscending);
  [id(3)] HRESULT TertiaryKey([in]int columnindex, [in]BOOL bAscending);
  [id(4)] HRESULT Apply();
  [id(5)] HRESULT PrimaryCustomKey([in]int columnindex, [in]IXlsList* list, [in]BOOL bAscending);
  [id(6)] HRESULT SecondaryCustomKey([in]int columnindex, [in]IXlsList* list, [in]BOOL bAscending);
  [id(7)] HRESULT TertiaryCustomKey([in]int columnindex, [in]IXlsList* list, [in]BOOL bAscending);

}

HRESULT PrimaryKey([in]int columnindex, [in]BOOL bAscending);
sets the column that serves as the primary key for sorting.

HRESULT SecondaryKey([in]int columnindex, [in]BOOL bAscending);
sets the column that serves as the secondary key for sorting.

HRESULT TertiaryKey([in]int columnindex, [in]BOOL bAscending);
sets the column that serves as the tertiary key for sorting.

HRESULT Apply();
sorts the data in the range, according to the sorting keys.

HRESULT PrimaryCustomKey([in]int columnindex, [in]IXlsList* list, [in]BOOL bAscending);
sets the column that serves as the primary key for sorting using a custom list.

HRESULT SecondaryCustomKey([in]int columnindex, [in]IXlsList* list, [in]BOOL bAscending);
sets the column that serves as the secondary key for sorting using a custom list.

HRESULT TertiaryCustomKey([in]int columnindex, [in]IXlsList* list, [in]BOOL bAscending);
sets the column that serves as the tertiary key for sorting using a custom list.