Page 1 of 1
sort like Excel "expanding sort"
Posted: Thu Nov 14, 2019 1:45 pm
by kindman
Hey, good time
Is it possible to expanding sort in columns? (XLSReadWrite) Because sorting the column will only sort the same column, not adjacent rows
How to sort like expanding sort Excel?
Re: sort like Excel "expanding sort"
Posted: Thu Nov 14, 2019 2:20 pm
by larsa
Hello
Yes, you can do do. Use:
Sort(ACol1, ARow1, ACol2, ARow2: integer; const AAscending,ACaseSencitive: boolean);
Example:
XLS[0].Sort(0,0,1,9,True,False);
Re: sort like Excel "expanding sort"
Posted: Sat Nov 23, 2019 6:09 am
by kindman
Thanks for the post but if we want to sort by column 1 to row 9 but columns after column 1 will not be moved accordingly (if sort by column 1)...
Re: sort like Excel "expanding sort"
Posted: Mon Nov 25, 2019 12:19 pm
by larsa
Hello
Do you have an example on how to do this sort? You can send me an Excel file with before and after sorting.