Sorting Sheet on Column 2 then 3

[obeltrami]

Hi,

I am trying to sort an XLS sheet using the TXlsSheet.Sort() method (the one with row1 row2 col1 col2 ...) but I cannot get it to work. Either I select all columns and then things are sorted according to the 0th row, or I select specific rows and then only these columns are sorted making the sheet data meaningless as rows are broken.

How can I simply sort a sheet from row1 to row2, ordered by col1 then col2 ?

Very best regards,

Olivier

[larsa]

Hello

When sorting, only the cells within the selected area are sorted. Entire rows or columns are not sorted. Maybe this can be added in a future update.