When I select the sort option from left to right, it still does sort from top to bottom.
That's the major fault, but the sorting is a major bug and ui collection:
* sort options are not sticky: when you do select the same range of data again, the former option such as "Range contains column labels" is not kept.
* sort now failed with the option of column labels: it did show the column labels to select from, but it still did include the labels within the sorting, thus moving the first row downwards
* the selection of sort criteria is very user unfriendly. If you want to see a better implementation, check e.g. FileMaker: A left column with available fields (labels), a right column to move the fields over and the option to reorder the selected fields (labels) - either by drag'n'drop or with up/down arrows
* the major requirement to use the pop up lists is not user friendly. It's a poor copy of Excel, while over there you still may edit the selection by hand, e.g. to enter both the label or identifiers such as "column z"
* field selection should trigger automatic sort options: when I do select the full table, full columns or full rows, it's very probable that this selection would include range labels. On the other hand, selection of a few cells only probably could mean no range labels, but data only.
Using OS 10.6.8 with LO 18.104.22.168
Sort option from left to right works as long as "Range contains column labels" is not checked.
Once checked, sort from left to right doesn't work at all (which is not totally unexpected).
But this option is far too sticky - it is impossible to get rid of it. You may uncheck it, but horizontal sort don't work and when reopening dialog, it is still there.
But sorting top-down respects column labels once it is checked.
Seems to be the newest version of bug https://bugs.freedesktop.org/show_bug.cgi?id=53482
UI improvements sound good - moved to a new issue id=55852
Platform removed - seems to be a long lasting problem not only for Mac OS
I mark this one as DUP of Bug 55485 because description there is more precise.
*** This bug has been marked as a duplicate of bug 55967 ***