Description: The sort direction as set in the data > sort, tab options does not actually perform to the setting. If set to column sorting it actually sorts on rows, and vice versa. Steps to Reproduce: 1.Create spreadsheet, or use any existing 2.Go to data -> sort dialog 3.Tab: options 4.mark: left to right (sort columns) 5.go to tab: sort critera Actual Results: sort key 1 is row 1 opening selection arrow displays all row numbers Expected Results: sort key 1 should be column A opening selection arrow should display all column letters Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.0.3 Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e CPU threads: 4; OS: Mac OS X 10.15.6; UI render: default; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded Sorting does happen according the sort criteria! So it seemsd that only the options dialog is wrong.
*** Bug 135969 has been marked as a duplicate of this bug. ***
It's fine being row 1, with left to right you are sorting the column not the rows. Help: https://help.libreoffice.org/latest/en-US/text/scalc/01/12030200.html?&DbPAR=CALC&System=WIN Direction Top to Bottom (Sort Rows) Sorts rows by the values in the active columns of the selected range. Left to Right (Sort Columns) Sorts columns by the values in the active rows of the selected range.