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
Everything is horribly slow as described in Description
Responsiveness shouldn't change. At most, recalculations might take longer, but actions that don't make any changes should not be affected
User Profile Reset: No
[Information automatically included from LibreOffice]
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no
[Copied from About LibreOffice]
Version: 22.214.171.124 / 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
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,
OpenCL was already disabled
After it got slow I tried restarting the app, upgrading from Dev 126.96.36.199 to Prerelease 188.8.131.52, 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 184.108.40.206) 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