Description: This is the first time that I have experienced this problem in ten years. Today, I opened an existing spreadsheet file and it takes a very long time (two to three minutes) to open. I receive an error message "LibreOffice Calc is not responding". I am running the Ubuntu 20.04LTS operating system with the newest version of LibreOffice suite on a HP Pavilion dv7 laptop with 16GB RAM and a 750GB SSD. Today, I backed up my data files using the Ubuntu Backups utility app as I always do every Thursday. Normally, files open with in 20 seconds. I have done nothing different than I have done for the last ten years. I know my way around LibreOffice Calc. I think that there was a recent update to my computer a couple of days ago. I do not know if the problem is with Ubuntu or LibreOffice updates. I never had this problem with Ubuntu 18.04LTS and the respective LibreOffice suite. Steps to Reproduce: 1.Open file from File manager. 2.Takes 60 seconds to show spreadsheet, but cursor is locked up and doesn't move. 3.After about 2 minutes, the cell location box will move with cursor arrows, but will lockup after moving approximately 40 rows. Mouse pointer is ineffective. Program is locked up and unresponsive. This time there is no Error Message. Actual Results: I use File manager to find an existing spreadsheet file. Open the file. File will take an excessive time to open. After opening, various basic features on the menu bar are inaccessible. Cursor will freeze in one location and will not move. Expected Results: I expect the spreadsheet to do basic functions Reproducible: Always User Profile Reset: No Additional Info: This problem just happened to me today. Never happened before. I suspect a recent software upgrade suggested by Ubuntu. Maybe a recent LibreOffice upgrade. Tried to open an existing file again. File opened after 45 seconds. I can change cell locations, but I cannot edit the contents of the cell. After 4 1/2 minutes, I receive the error message "LibreOffice Calc is not responding".
Please try Menu/Help/Restart in Safe Mode.
Dear Stephen Smith, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
I gave up because I was disgusted with the performance of the new Libre Office Calc. I never should have had to open up Calc in Safe mode. I removed the entire Ubuntu 20.04 operating system along with Libre Office 6 suite off my computer. I reverted back to Ubuntu 18.04 with its Libre Office 5 suite. I did create a problem in that the last backup that I made was under Ubuntu 20.04. When I tried to restore all my files after reinstalling Ubuntu 18.04, the Backup utility could not recognize the files on my backup USB drive. I had to learn how to create cryptic Terminal commands for the Duplicity backup utility. I was able to restore 95% of all my files. Now that I am back using Ubuntu 18.04 and Libre Office Calc 5, my spreadsheets are working flawlessly. This is the first time that an upgrade from Libre Office had negatively affected me. I may never trust your upgrades again. I know that Ubuntu upgrades are not trust worthy. Again, I was so unhappy with your support that I decided to revert backwards. Best decision that I have made in a while.
[Automated Action] NeedInfo-To-Unconfirmed
I have similar on MacOS. Lockup after the sheet is loaded and displayed (double click in desktop)
Created attachment 174961 [details] See above
Created attachment 174962 [details] See above
(In reply to bz137195 from comment #7) > Created attachment 174962 [details] > See above For me open instantly Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL We are not your support, but the QA team supporting LibreOffice, mainly volunteers in our free time. You could have gone to https://ask.libreoffice.org/c/english/5, where it's easier to find help, a lot of people helping, before coming here to report a bug. In any case, thank you for your kind words, they encourage us to keep going. And make a better LibreOffice among others for you.
A new major release of LibreOffice is available since this bug was reported. 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.
Dear Stephen Smith, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp