https://bugs.documentfoundation.org/show_bug.cgi?id=146546
Bug ID: 146546
Summary: Calc unusably slow after adding a column of SUMIF
Product: LibreOffice
Version: 7.3.0.1 rc
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
