Description: When trying to sort rows in a spreadsheet, calc hangs *the second time*. So, I can sort once, but when I try to sort a second time, it hangs/freezes and must be killed. Steps to Reproduce: 1. Open csv 2. Save as .ods (optional) 3. Select specific rows 4. Data > Sort > sort by column A and B (works fine) 5. Data > Sort > sort by column C --> hang Actual Results: Calc hangs and must be killed. Expected Results: should sort like the first time. I did this exact thing 3 months ago and it worked fine. Since then, I got 6.4.4.2. So, it looks like a new bug that was recently introduced. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Okay, so I just check the old .ods file that I mentioned, which was created by doing the exact same procedure on very similar data, and now *that* file also causes Calc to hang on the *first* sort.
Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? If the problem persists, please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Yeah, I can reproduce in safe-mode. But, if I delete too much data, it does not reproduce. So, looks like you will need the data. I have sanitized the document and can upload it.
(In reply to PMouse from comment #2) > Yeah, I can reproduce in safe-mode. > > But, if I delete too much data, it does not reproduce. So, looks like you > will need the data. I have sanitized the document and can upload it. Please do
Created attachment 161740 [details] Reproducer File This file reproduces the problem, but only columns A&B will not, so it seems like it is related to the data, somehow, or the amount of data. To reproduce: 1. select the whole sheet 2. Data > Sort 3. Choose to sort all rows by column L 4. Next, go to Data > Sort, again, which hangs.
(In reply to PMouse from comment #4) > Created attachment 161740 [details] > Reproducer File > > This file reproduces the problem, but only columns A&B will not, so it seems > like it is related to the data, somehow, or the amount of data. > > To reproduce: > > 1. select the whole sheet > 2. Data > Sort > 3. Choose to sort all rows by column L > 4. Next, go to Data > Sort, again, which hangs. I can't reproduce it in Version: 7.1.0.0.alpha0+ Build ID: 8bbd8324282e7890de29ede5912d24c6e1c7ce7f CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Could you please paste the info from Help - about LibreOffice ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the information has been provided
Is this what you want? Version: 6.4.4.2 Build ID: 6.4.4.2-2.fc32 CPU threads: 16; OS: Linux 5.7; UI render: default; VCL: gtk3; Locale: en-US (en_US.utf8); UI-Language: en-US Calc: threaded
Thank you for reporting the bug. I can not reproduce the bug in: Version: 7.1.0.0.alpha0+ (x64) Build ID: ba33a51ff1eb34a5983870dcb50e975002e6d3a4 CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
Can you explain what that means for this bug? Why did you test alpha?
(In reply to PMouse from comment #8) > Can you explain what that means for this bug? Why did you test alpha? It is useful to test with daily builds to get an indication of the current state. Can you try with a daily master build: https://wiki.documentfoundation.org/Installing_in_parallel/Linux#Automated_installation or grab one here https://libreoffice.soluzioniopen.com/index.php/daily-version/
Okay, I also cannot reproduce with the daily.deb->appImage version. Since I reported this bug, my distro has updated from 6.4.4.4 to 6.4.6.2 and I still have the problem. FYI. AFAIK, I will not get access to v7.0 until the next release of my distribution, which will not be before the end of October. Also, it's not clear that newer versions will ever land on this release, so, unless this bug is fixed in v6.4, it will live on for a at least another year for these users.
[Automated Action] NeedInfo-To-Unconfirmed
Hello PMouse, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
I cannot reproduce the bug with v7.2.4 downloaded from the site and installed locally, not globally. BTW, how do I uninstall this? I cannot find any instructions.
(In reply to PMouse from comment #13) > I cannot reproduce the bug with v7.2.4 downloaded from the site and > installed locally, not globally. > > BTW, how do I uninstall this? I cannot find any instructions. Not sure about the uninstall as I never install like that, but maybe this provides some clues: https://wiki.documentfoundation.org/Documentation/Install/Linux The request for testing should have pointed to your distro package, however. Which distro are you using and is the bug gone in the latest packaged version?
(In reply to Buovjaga from comment #15) > (In reply to PMouse from comment #13) > > I cannot reproduce the bug with v7.2.4 downloaded from the site and > > installed locally, not globally. > > > > BTW, how do I uninstall this? I cannot find any instructions. > > Not sure about the uninstall as I never install like that, but maybe this > provides some clues: > https://wiki.documentfoundation.org/Documentation/Install/Linux Hmm. Thanks, but no. > The request for testing should have pointed to your distro package, however. > Which distro are you using and is the bug gone in the latest packaged > version? Fedora. The download gave me many relocatable RPMs. I just ran the installer script that came with the download, which seemed like it was the preferred installation method. But, that script doesn't have any uninstall option, and the RPMs were not installed, just unpacked, it seems. I'm guessing I can just delete the directory where they were installed, but it would be nice to know for sure. Latest LO packaged for F34 is v7.1.7.2 and it does not exhibit this bug.
I didn't test LO in F35, which is the latest release, though.
Great to hear, let's close.
F35 has v7.2.4.1. ... I was unable to reproduce in 7.2.4.1 on F35, either.
Hmm, I mean, I guess it doesn't matter, but, I did confirm this bug, exactly as requested. I think FIXED is clearly a more accurate resolution.
(In reply to PMouse from comment #20) > Hmm, I mean, I guess it doesn't matter, but, I did confirm this bug, exactly > as requested. I think FIXED is clearly a more accurate resolution. Please see https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/RESOLVED#The_Meaning_of_RESOLVED