https://bugs.documentfoundation.org/show_bug.cgi?id=148094
Bug ID: 148094
Summary: Calc Hangs and uses ever increasing amount of memory
with lots of MATCH(1, ("X"=range) * ("Y"=range), 0)
EDITING/OPENING
Product: LibreOffice
Version: 7.1.8.1 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a 2.5MB spreadsheet with which uses lots of INDEX(range,MATCH(1,
("X"=range) * ("Y"=range), 0),1) formulas (to do a lookup based on two
criteria).
If you open this spreadsheet, or randomly afterwards LibreOffice hangs and
starts using experiential amounts of RAM. I have 8GM ram and if I don't force
quite before it gets to 5/6GB just for libreoffice the whole complete locks up.
Open with autocalculate off isn't possible (and having auto calculate on/off
doesn't seem to matter). If you open the same file in MS Excel 2011 it opens
fine.
I've created a simplified version of this spreadsheet which is smaller, and
only contains the formulas above (see attached). Although this doesn't crash at
open very often. It does fairly regularly exhibit the same behaviour where it
hangs and start using ever more RAM as the bigger spreadsheet does. I've not
been able to deduce what causes this.
There is also performance issue with calculating spreadsheet with such
formulas. A sheet with 400 such formulas (with Multithreading enabler take a
good few minutes too calculate (even with multithreading on it still only seems
to use one core's worth of CPU).
And odd other performances issues, like it taking 10 seconds to add a new sheet
(which is doesn't happen on other spreadsheets). Saving taking 30secs
sometimes, but weirdly not always (that's on MATCH()_CRASH_DEMO.xlsx with files
size of 200Kb or bigger).
OS Version: Mac OS X 10.14.6 (Build 18G9323)
Architecture: x86_64
Command: soffice
Path:
/Applications/Downloaded/LibreOffice.app/Contents/MacOS/soffice
Identifier: org.libreoffice.script
Version: 7.1.8.1 (7.1.8.1)
PID: 60566
Event: hang
Hardware model: MacBookPro9,2
Active cpus: 4
RAM: 8GB
Hard Drive: 960GB ScanDisk Pro SSD (SanDisk SDSSDXPS960G)
Graphics: Intel HD Graphics 4000
Tried turning on OpenCL --> Doesn't seem to be available with computer
hardware.
Tried turning off Multithreading --> Doesn't seem to make any difference
I've run out of time to keep compiling this bug report. I think I've produced
replicable example I could upload, and then I re-open libreoffice in safe mode
and struggled to repeat the expolnencail increase in memory use with DEMO
spreadsheet. I've definetly crashed full 2.5MB spreadsheet in safe mode, but so
far not the DEMO on I've attached. I'll keep using it in safe mode and see how
long that last. I can upload my user profile if that's helpful.
Steps to Reproduce:
Reproducing the slow performance on INDEX(MATCH) formulas is very easy:
1. Open spreadsheet attached
2. Go to first sheet 'INDEX(MATCH)'
3. Drag down another 100 rows.
Reproducing the memory fault is harder to pin down.
1. Open spreadsheet attached
2. If that's not enough then trying to work on it for a few minutes is usually
sufficient
3.
Actual Results:
Hang + Memory Leak a seemingly random intervals.
Hang without memory increase for long time whilst calculating.
Expected Results:
Calculations that take significant amount of time should not lock up UI, or
cause application to be un-responsive. They should just stop use editing
spreadsheet and indicate some how that recalculation is in progress.
Under no circumstance should LibreOffice start using infinitely more RAM until
computer locks up.
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Not sure if either of these bugs relate to issues I'm having:
https://bugs.documentfoundation.org/show_bug.cgi?id=139444
https://bugs.documentfoundation.org/show_bug.cgi?id=144142
Due to this bug I can't run latest version:
https://bugs.documentfoundation.org/show_bug.cgi?id=148069
--
You are receiving this mail because:
You are the assignee for the bug.
