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.
*** This bug has been marked as a duplicate of bug 135968 ***