1. Create a new spreadsheet. 2. Open Data->Sort. 3. On "Options" tab, confirm that "Top to bottom (sort rows)" is *pre-selected* in "Direction". 4. Save the file as ODS. 5. Close and reopen the ODS. 6. Open Data->Sort. 7. On "Options" tab, see that "Left to right (sort columns)" is *pre-selected* in "Direction". 8. Save as XLSX. 9. Close and reopen the XLSX. 10. Confirm that #3 is true again. The problem is #7; the direction re-setting to "Left to right (sort columns)" without anything configured is wrong. Seen in master, and in Version: 7.2.2.1 (x64) / LibreOffice Community Build ID: 0e408af0b27894d652a87aa5f21fe17bf058124c CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL. Also seen in Version 3.6.0.4 (Build ID: 932b512). Not repro using LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Not repro. Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded Not repro. Version: 7.1.6.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.1.6~rc2-0ubuntu0.20.04.1~lo1 Calc: threaded
The problem was in the interpretation of "confirm" in # 3. You need to open the corresponding dialog and close it without clicking the OK button. Reproduced in both of the above versions.
35all: https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=cc9a10185749210825fe6970ea4b103eb78e329e..1118f57582aaa7275a8fe1d1460e1515c111ac2e Rather large range. Mike, please see if you can spot the culprit.
(In reply to Timur from comment #3) Thanks! https://git.libreoffice.org/core/+/ed88b144ce24b9a733d4a9ab6614307c96537baa seems suspicious.
https://gerrit.libreoffice.org/c/core/+/122955
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d830179a072072f3cc3ea5d942189647bcb7e1c7 tdf#144758: default value for 'table:orientation' attribute is 'row' It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/7a31f198af9e7f2b53a0eb9cc3fb473a265fab45 tdf#144758: default value for 'table:orientation' attribute is 'row' It will be available in 7.2.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.