Description: This phenomenon has appeared since the July 2022 update. Here is my checked ver. 7.3 -> none 7.4.0.3 ->have 7.4.2.3 ->have AND↓ Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 5a1f41a0d3aab15c113651f2edc9d4137ae99063 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded Steps to Reproduce: 1.Start calc 2.Do Data>sort. 3.Open sorting option>sorting oreder or 2.Open tool>option>LOC>order list Actual Results: default list1 default list2 default list3 default list1 default list2 default list3 (and more...) my list1 See ->http://imepic.jp/20221017/107470 Expected Results: default list1 default list2 default list3 my list1 Reproducible: Always User Profile Reset: Yes Additional Info: The number of times the list grows seems to be random. At 7.4.0.3 it seemed to proliferate with every start LOC.
Hi Marina I had a look in the options and only see 4 lists: 2 weekday lists, and 2 month lists. Same thing in the Sort dialog, Options tab, Custom sort order dropdown: only 4 lists. Starting again Calc does not duplicate the lists for me. What are those "default lists" you have? Are they custom ones you have created? (Or maybe they are related to the Japanese UI?) Have you tried using Calc in Safe Mode to see if the issue remains? Thank you! Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0cf5141b2233611286a27930d8030c562eb0d84b CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Instructions for Safe mode (and user profile reset if needed) are here: https://wiki.documentfoundation.org/UserProfile#Backup_first If you reset your user profile, please make sure the information it contains is not important (or make a backup as described).
*** Bug 152001 has been marked as a duplicate of this bug. ***
Hi. The Red box list is calc's default list. I tried safe mode, update, and install dev ver. セーフモードも試した、全部削除もした、アップデートもした、それでも治らないからDevモードにインストールし直した。全部ダメなので報告しました。 おそらくこの問題を直すには、報告内に書いた「問題なかったバージョン」まで遡ってダウングレードが必要になると思う。
書いてなかった・・・ たしか6.3か6.4あたりまでは正常だった。 This "default" list is Japanese Calendar and days of the week list. January、February、March.... Sunday、Monday....
Thank you, Marina! Also reproduced in: Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ab4e40941e9ebae83f98ba918440b03eac5bdcaa CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Steps: 1) Delete a default list in Tools > Options > Calc > Sort lists 2) Close a reopen Calc, see sort lists The full set of default lists is added in again. Also in: Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded But works as expected in: Version: 7.3.6.2 / LibreOffice Community Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Hi Stéphane. Thanks to check many versions. Both the current version and 7.5 have other fatal problems(reported by other members), so I will return to the version you told me for the time being. Thanks.
Cannot bibisect, good in linux-64-7.3 master, bad in linux-64-7.4 oldest
*** Bug 151576 has been marked as a duplicate of this bug. ***
I had to reset the user profile at each step for bibisecting. Bisected to: 134d209cb8962a71d3420e0e50220cc476612f62 is the first bad commit commit 134d209cb8962a71d3420e0e50220cc476612f62 Author: Jenkins Build User <tdf@pollux.tdf> Date: Tue Nov 30 19:34:31 2021 +0100 source 8810812e58f1b014d3156235c1ab5a2d6c73c828 instdir/program/libsclo.so | Bin 21523808 -> 21529408 bytes instdir/program/libscuilo.so | Bin 940184 -> 940184 bytes instdir/program/setuprc | 2 +- instdir/program/versionrc | 2 +- 4 files changed, 2 insertions(+), 2 deletions(-) Which points to: commit 8810812e58f1b014d3156235c1ab5a2d6c73c828 author Mike Kaganski <mike.kaganski@collabora.com> Sun Nov 28 23:58:40 2021 +0200 committer Mike Kaganski <mike.kaganski@collabora.com> Mon Nov 29 03:54:26 2021 +0100 tree 14d7af8f7c402331e96b10b801fe9e6713b26a86 parent b2c56ac95b15b675b9fabed889e7f9709bdc793f tdf#132145: Synchronize ScAppCfg with configuration The commit modifies the file that contains the user sort lists: https://opengrok.libreoffice.org/xref/core/test/source/sheet/globalsheetsettings.cxx?r=27f98935#123 Can you please have a look, Mike? Thanks!
https://gerrit.libreoffice.org/c/core/+/152579
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e0c7d7bc511c90e820adaaebb14ca8175364371d tdf#151987: clean default list before using non-default one It will be available in 7.6.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.
*** Bug 155657 has been marked as a duplicate of this bug. ***
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/9f7e3560ba3ecdf52bc5b9637485fea57ae1b132 tdf#151987: clean default list before using non-default one It will be available in 7.5.5. 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.
Thanks, Mike. Just once now. Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: e855481ead996a3b8270fae91bd23d6c8d75ef25 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Verified
Still happening in current Dev versions 24.2. Possibly some branch split happened during the push to 7.6?
(In reply to ady from comment #17) > Still happening in current Dev versions 24.2. > > Possibly some branch split happened during the push to 7.6? No, sorry. Resetting everything and following steps from comment 6 > no longer repro. Closing again.
7.5.4.2 has this probrem. NOT SOLVED.
(In reply to MARINA-SODA from comment #19) > 7.5.4.2 has this probrem. > NOT SOLVED. Please read comment 14: "It will be available in 7.5.5."
Sorry Thanks