Description: I wanted to add partial sums to a ~100KB .ods file, so I added column AC so cell AC_n contains `=SUMIF(O$2:O$999,O_n,X$2:X$999)`. The values are correct, but after adding that column it takes a few seconds to do anything in this file, including switching back to LibreOffice from another app, moving which cell is selected, scrolling, copying a cells to the clipboard, etc, etc Steps to Reproduce: Add a column of SUMIFs as described in Description Actual Results: Everything is horribly slow as described in Description Expected Results: Responsiveness shouldn't change. At most, recalculations might take longer, but actions that don't make any changes should not be affected Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Mac OS X (All) OS is 64bit: no [Copied from About LibreOffice] Version: 7.3.0.1 / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 16; OS: Mac OS X 10.16; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded [OS Info] macOS Big Sur 11.6.2 [Things I tried] Based on forum posts I tried to disable OpenGL, but it looks like the options have changed so that there's no OpenGL option. I disabled hardware acceleration, anti-ailiasing, and using Skia for all rendering, with no discernible effect. Multi-threaded calculation is enabled
Please, attach a sample file. BTW, I think it's OpenCL in the options, not OpenGL, the last it's about Graphics in View, https://help.libreoffice.org/latest/en-US/text/shared/optionen/opencl.html?DbPAR=SHARED#bm_id4077578
OpenCL was already disabled After it got slow I tried restarting the app, upgrading from Dev 7.3.0.0 to Prerelease 7.3.0.1, fiddling with the settings and restarting multiple times, all with no effect, so I filed this bug. Since then LibreOffice crashed on its own, and after restarting from the crash it's not being unusably slow anymore. I guess something got into a bad state that persisted across all the restarts, the upgrade, and the settings changes, but got reset by the crash. I'm not going to share the financial records I was working with when it happened, if the formula that triggered the problem isn't useful how do I construct a suitable sample?
[Automated Action] NeedInfo-To-Unconfirmed
*** This bug has been marked as a duplicate of bug 144777 ***
I'm not sure this is a duplicate of bug 144777; it happened again yesterday making a similar change to a different file (this time with COUNTIF), and the calculation took at most a few seconds, but it made the app (Prerelease 7.3.0.1) unusable for the rest of the day. I left it overnight to see if it would finish, and this morning it was still unusable; I told it to close about 4 hours ago and it never finished closing. After forcequitting just now it did not bring up the document recovery, and it seems to have recovered and be updating the COUNTIF cells with no noticable delay