Description: When switching between spreadsheets, saving spreadsheets (especially autosave) older software would lock up with a processor core maxed out. Patience was required. With this version of calc, the software locks up but there is no processor activity. No amount of patience helps. Terminating the app and consequential loss of data is the only option. Steps to Reproduce: 1.Switch spreadsheets while one is busy 2. 3. Actual Results: The box "wait" or "terminate app" box comes up Selecting wait has no effect Expected Results: Well, ideally the work I am doing on one spreadsheet or other libreoffice document should be unaffected by the work of any other spreadsheet. If this is too much to ask, reverting to a situation that required me to wait would be better. Reproducible: Sometimes User Profile Reset: No Additional Info: The situation is so bad that I now work with the aid of system monitor. It does look like a deep seated locking problem.
Steps must be reproducible, please attach a non-personal sample ODS. Did you try to turn on Options-Calc-Defaults-"very large spreadsheets"? With bug 133764. Do you use Options-Calc-Calculate-"multi-threaded calculation"? With bug 114159. Please paste Help-About info. Please test with master from https://dev-builds.libreoffice.org/daily/master/current.html
And please test with a clean profile, Menu/Help/Restart in Safe Mode
Do you use Options-Calc-Calculate-"multi-threaded calculation"? Yes Yes, I do a lot of COVID-19 modelling, I tried this in the hope autosaves and calcs would be quicker. A clean profile has fixed the deadlock so far, but not the performance. No multithreading.
Do you have enable Menu/Tools/Options/LibreOffice/OpenCL?
(In reply to Mark Dunn from comment #3) > A clean profile has fixed the deadlock so far, but not the performance. No > multithreading. Please make clear, what is this bug about now? With sample and steps. Do you mean that you don't use option or you don't really see multithreading?
This problem happened after an upgrade (or multiple upgrades) multi-threaded calculation was set when deadlocking occurred I have not tried to turn on Options-Calc-Defaults-"very large spreadsheets After I reset to factory settings reset settings reset entire profile multi-threaded calculation is STILL set but the deadlocking problem has gone. I do not know if Menu/Tools/Options/LibreOffice/OpenCL was set initially as I have reset to factory settings. After the reset I have tried and allthough I can enable it and it asks for restart. It is still not enabled. I will continue to investigate my multithreading and raise it as a separate issue when I am able to define it better.
(In reply to Mark Dunn from comment #6) >... > I do not know if Menu/Tools/Options/LibreOffice/OpenCL was set initially as > I have reset to factory settings. After the reset I have tried and allthough > I can enable it and it asks for restart. It is still not enabled. > ... If OpenCL it's not enable after restart, it's because doesn't pass the test. Maybe you need to update graphics card driver.
Dear Mark Dunn, 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
(In reply to Mark Dunn from comment #6) > After I reset to factory settings .. the deadlocking problem has gone. This was left open but should have been closed. I do it now. We don't know the cause. Please note that "User Profile Reset:" in report form indicates instruction to try with new profile/profile reset first. And it helped here. If not, tests with "very large spreadsheets" and "multi-threaded calculation" and OpenCL can further pinpoint the issue.