Description: I've been using LibreOffice Calc since 2006 and only for 2 spreadsheets: BUDGET 20nn and Vehicle Costs, which I typically use whenever I have a transaction to record (i.e. which is not every day). According to my Notes journal, I first encountered a spinning wheel on 2023-1-27 while EDITING spreadsheet BUDGET 2023, that seemed unrelated to anything I was doing at the time. It was the first time I could recollect ever encountering a spinning wheel in Calc. So I dismissed it as just one of those things. However, over the ensuing days, it reoccurred, and more frequently, to the point where I would do saves every couple changes. Curiously, I didn't encounter a spinning wheel while EDITING spreadsheet Vehicle Costs. So, today I thought it was high time I check to see if there was an upgrade available (that might resolve the problem). So, I downloaded and installed 7.4.5.1. But instead of resolving the problem, it made it worse. I would get the spinning wheel immediately upon FILEOPEN the BUDGET 2023 spreadsheet. And now I would also get the spinning wheel in the Vehicle Costs spreadsheet, simply by alternately selecting 3 different cells after FILEOPEN. This happened consistently each and every FILEOPEN. I tried starting LibreOffice in Safe Mode > Reset to factory settings, which resulted in the BUDGET 2023 coming up alright, but after alternately selecting 3 different cells, the spinning wheel occurred. Tried starting LibreOffice in Safe Mode > Reset to factory settings > Reset entire user profile, but with spreadsheet Vehicle Costs. Simply alternately selecting different cells was OK for a short while, but then the spinning wheel reoccurred. At that point I bailed out and went to Time Machine to revert to an older version of LibreOffice.app. Going back in time, I discovered the previous change to 7.0.3.1 was saved on 2023-1-20. Since this was just 7 days prior to the first occurrence of the spinning wheel I had recorded in my Journal, I went back further in Time Machine to the next previous change to 7.0.3.1, which was on 2022-10-22, and restored it. Lo and behold, opening BUDGET 2023 with that version seems to have resolved the spinning wheel problem, at least for now. If that holds, it would implicate one of the changes to 7.0.3.1 made between 2022-10-22 and 2023-1-20. Hope the symptoms I've described above will help narrow down to identify the particular change. (btw, the symptoms I've described above seem very similar to those in BUG 149807, but I defer to you.) Actual Results: Please see Description above. Expected Results: Please see Description above. Reproducible: Always User Profile Reset: Yes Additional Info: Please see Description above.
I may be wrong but the hang you see sound more like issue 152567. Issue 149807 was fixed in LibreOffice 7.4.4 so one way to figure out which issue you are seeing is to download LibreOffice 7.4.5 or 7.5.0 from the following link: https://www.libreoffice.org/download/download-libreoffice/ Does the hang still occur with either of those LibreOffice versions? If yes, then it is probably issue 152567 or a new bug.
Hi Patrick. As mentioned in the Description, "So, I downloaded and installed 7.4.5.1. But instead of resolving the problem, it made it worse."
(In reply to JackVos from comment #2) > Hi Patrick. As mentioned in the Description, "So, I downloaded and installed > 7.4.5.1. But instead of resolving the problem, it made it worse." I definitely missed that section. Anyway, I think the next step is to try to obtain a "sample file" when LibreOffice is hanging. Are you familiar with the macOS Activity Monitor application? In the Finder, it is in the /Applications/Utilities folder. I will ask the same in issue 152567. If we can get a one or more sample files from people experiencing this, that should narrow down what is causing this bug.
No, I'm afraid I don't. I just started it up to have a look and didn't see any file options. So, you'll need to spell out exactly what you'd like me to do. Thank you.
I found the following links. The first is how to launch Activity Monitor from the Finder. The second is a section further down on the same webpage that instructions for saving a sample file. It is a bit old, but the instructions are still almost exactly the same on newer version of macOS: http://thexlab.com/faqs/activitymonitor.html#AM-Basics http://thexlab.com/faqs/activitymonitor.html#AM-Sample-Process The one change in newer versions of macOS is that the "Sample Process" toolbar button has moved. Now there is a "..." toolbar button. Click on that button and select "Sample Process" in the popup dialog that appears. Once you obtain a sample and save it to a file, you can upload the file by clicking on the "Add an attachment" link just above this bug's comments section. Hope that helps.
Created attachment 185334 [details] macOS Activity Monitor file of LibreOffice 7.4.5.1 in hung state
Hi Patrick. Just prior to "Comment 6", I had documented the steps I had taken leading up to taking a "Sample Process". But I had neglected to select the file before clicking on "Save Changes". Selecting and uploading the file superseded the original "Comment 6". Am I making sense? So, I'll re-enter those comments so you'll know what I did and what you're looking at. First, did a dry run of AM with LibreOffice 7.4.5.1 and document "BUDGET 2023". Left it in a hung state for 3 minutes before "Force Quit". Terminated all other activities/processes except Finder. 1. Started AM. 2. Started LibreOffice 7.4.5.1. 3. Searched for LibreOffice in AM and selected it. Exited "Search". 4. Selected/Opened file BUDGET 2023 in LibreOffice. (Spinning wheel appeared immediately.) 5. Clicked on "..." in the AM Toolbar and selected "Sample Process". 6. Saved file to Documents/Sample 1 of LibreOffice 7.4.5.1. Presumably, this will tell you what LibreOffice is hung up about, but not why. Hope this helps, though.
Thank you for the Activity Monitor sample file. It really helps. What I see in the sample file is that LibreOffice is stuck retrieving the contents of every cell in the current spreadsheet in response to a macOS accessibility query. A lot of macOS tools (e.g. window snapping applications) use macOS accessibility to send queries or commands to another application. I was able to reproduce this bug in LibreOffice 7.4.5.1 by turning on macOS VoiceOver and then opening either a new, empty spreadsheet or an existing spreadsheet. Interestly, I cannot reproduce the bug in LibreOffice 7.5.0. I know that a few macOS accessibility bugs were fixed in LibreOffice 7.5.0. That version is newer so it probably has its own set of bugs, but maybe LibreOffice 7.5.0 is worth a try for you?
Ok Patrick. I'll give that a go later today and will let you know the results. Thanks for all your help.
Hello Patrick. Just tried 7.5.0.3 with file BUDGET 2023. Didn't encounter the problem opening the file. Modified an existing row in the worksheet and did a sort without a problem. So, I think you can close Bug 153484, resolution: install LibreOffice 7.5.0. I'll stay on 7.5.0.3. If I encounter a problem, I'll assume it's a horse of a different garage. Thanks again Patrick. Appreciate your help.
Marking as resolved in LibreOffice 7.5.0.3.
...and then marking as closed.