Page 1 of 1

Sort On Multiple Columns

Posted: Sat Dec 26, 2020 9:09 pm
by obeltrami
Hello,

I searched for a way to sort by multiple columns (first D then A, for example) and I saw in the release notes that version 5.10 had "New Sort method for sorting columns. Can sort on multiple columns.".

But the 2 overloaded Sort() functions do not seem to allow to sort on multiple columns AFAIK. I also could not find it in the doc-o-matic documentation.

Could you share example code of sorting a sheet by column D then A, for example ?

Very best regards,

Olivier

Re: Sort On Multiple Columns

Posted: Mon Dec 28, 2020 2:30 pm
by larsa
Hello

Here is an example which will sort on columns C and D:

Code: Select all

XLS[0].Sort(2,0,4,XLS_MAXROW,True,True);

Re: Sort On Multiple Columns

Posted: Thu Sep 08, 2022 1:07 pm
by nagygabor679
Hi,
How can I sort whole table by X (any) column?
Thanks,
Gábor