 |
| 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);
[id(8),propput] HRESULT CaseSensitive([in]BOOL casesensitive);
[id(8),propget] HRESULT CaseSensitive([out, retval]BOOL* casesensitive);
[id(9),propput] HRESULT ByColumn([in]BOOL bycolumn);
[id(9),propget] HRESULT ByColumn([out, retval]BOOL* bycolumn);
[id(10)] HRESULT NewCondition([out, retval]IXlsSortCondition** cond);
}
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.
HRESULT CaseSensitive([in]BOOL casesensitive);
sets whether the sort is case sensitive. Default value is NO.
HRESULT CaseSensitive([out, retval]BOOL* casesensitive);
retrieves whether the sort is case sensitive.
HRESULT ByColumn([in]BOOL bycolumn);
sets whether the sort is performed by column. Default value is YES.
HRESULT ByColumn([out, retval]BOOL* bycolumn);
retrieves whether the sort is performed by column.
HRESULT NewCondition([out, retval]IXlsSortCondition** cond);
adds a sort condition.