Summary: | Calc unusably slow after adding a column of SUMIF | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Shad Sterling <me> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | me, miguelangelrv, telesto |
Priority: | medium | ||
Version: | 7.3.0.1 rc | ||
Hardware: | All | ||
OS: | macOS (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Shad Sterling
2022-01-03 13:26:56 UTC
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 |