[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Patrick Luby (volunteer) changed: What|Removed |Added Resolution|--- |WORKSFORME

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #36 from Noel Grandin --- (In reply to Patrick Luby (volunteer) from comment #35) > > OK. So last question and then I think we can mark this as fixed: in comment > #28 you mentioned seeing 2 GB of memory usage on macOS. Has

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #35 from Patrick Luby (volunteer) --- (In reply to Noel Grandin from comment #34) > I don't see anything that can obviously be improved in the the CPU usage. > This spreadsheet makes extensive usage of matrix operations. > Cal

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #34 from Noel Grandin --- I don't see anything that can obviously be improved in the the CPU usage. This spreadsheet makes extensive usage of matrix operations. Calc's matrix code is already fairly optimised. -- You are rece

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #33 from Patrick Luby (volunteer) --- So ignore all of my recent posts. I have been using my local debug build and apparently a debug build's extra assertions/tests/logging is the cause of most of the slowness I have seen. I

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #32 from Patrick Luby (volunteer) --- OK. I've narrowed things down a little more. After much trial and error, I found that the following debug patch lowers the time it takes to fill 100 rows from ~8 minutes to ~30 seconds on

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #31 from Patrick Luby (volunteer) --- (In reply to Patrick Luby (volunteer) from comment #30) > Created attachment 195272 [details] > Allocations before and during hang using Xcode's Instruments application So I ran the Leaks

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #30 from Patrick Luby (volunteer) --- Created attachment 195272 --> https://bugs.documentfoundation.org/attachment.cgi?id=195272&action=edit Allocations before and during hang using Xcode's Instruments application -- You a

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #29 from Patrick Luby (volunteer) --- (In reply to Noel Grandin from comment #28) > I am pretty sure that (2) still exists - on my macbook, Activity Monitor > says that LibreOffice is using 2G, while on Linux, hprof says that

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #28 from Noel Grandin --- So there are at least three different issues mixed up here (1) Peter reported a memory leak (2) Peter reported lots of memory being used (3) Roman reported high CPU usage when autofilling a sheet

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||ko...@libr

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #26 from Patrick Luby (volunteer) --- (In reply to Patrick Luby (volunteer) from comment #25) > I admit that I am not familiar with the code that handles range formulas > such as the INDEX() formula so it is not clear to me wh

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #25 from Patrick Luby (volunteer) --- (In reply to Patrick Luby (volunteer) from comment #24) > Created attachment 195212 [details] > CPU Profile during hang using Xcode's Instruments application I obtained the CPU Profile in

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #24 from Patrick Luby (volunteer) --- Created attachment 195212 --> https://bugs.documentfoundation.org/attachment.cgi?id=195212&action=edit CPU Profile during hang using Xcode's Instruments application -- You are receivin

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #23 from Patrick Luby (volunteer) --- (In reply to Noel Grandin from comment #22) > Interesting, I don't see a problem with current master, running on Linux. > It's slow, but nothing leaks and it doesn't lock up for more than

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #22 from Noel Grandin --- Interesting, I don't see a problem with current master, running on Linux. It's slow, but nothing leaks and it doesn't lock up for more than a couple of seconds here and there. -- You are receiving t

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Patrick Luby (volunteer) changed: What|Removed |Added CC||guibomac...@gmail.com

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #20 from Patrick Luby (volunteer) --- Created attachment 195201 --> https://bugs.documentfoundation.org/attachment.cgi?id=195201&action=edit Sample during hang using the Activity Monitor application -- You are receiving th

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #19 from Peter --- Hi QA Administrators, As requested I've just run a further tests on new version of LibreOffice. I can't run LibreOffice 24 on my main machine as I'm still running MacOS10.14 which isn't supported, however I

[Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #18 from QA Administrators --- Dear Peter, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Julien Nabet changed: What|Removed |Added CC||er...@redhat.com,

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Julien Nabet changed: What|Removed |Added OS|macOS (All) |All -- You are receiving this ma

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #16 from Julien Nabet --- Created attachment 179245 --> https://bugs.documentfoundation.org/attachment.cgi?id=179245&action=edit Flamegraph Indeed, I reproduced the hang. Here's a Flamegraph retrieved on pc Debian x86-64 wi

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirm

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #14 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #13 from Peter --- (In reply to Xisco Faulí from comment #12) > Could you please try to reproduce it with the latest version of LibreOffice > from https://www.libreoffice.org/download/libreoffice-fresh/ ? > I have set the bug'

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Com

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #10 from Peter --- Created attachment 178990 --> https://bugs.documentfoundation.org/attachment.cgi?id=178990&action=edit RAM Statistc - A few force quits in regular succession Note: compared of other screenshot I'd closed

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Peter changed: What|Removed |Added Attachment #178989|RAM Statistics -- After |RAM Statistics -- After descripti

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #9 from Peter --- Created attachment 178989 --> https://bugs.documentfoundation.org/attachment.cgi?id=178989&action=edit RAM Statistics -- After 2.5MB spreadsheet memory leak left for a while -- You are receiving this mail

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #8 from Peter --- Created attachment 178988 --> https://bugs.documentfoundation.org/attachment.cgi?id=178988&action=edit When I tried to archive user profile to upload -- You are receiving this mail because: You are the as

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #7 from Peter --- Created attachment 178987 --> https://bugs.documentfoundation.org/attachment.cgi?id=178987&action=edit Screenshot of RAM stats during LibreOffice Hang + Memory Leak This was probably 10-20 seconds after it

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #6 from Peter --- Created attachment 178986 --> https://bugs.documentfoundation.org/attachment.cgi?id=178986&action=edit Screenshot of hang while calculating lots of INDEX(MATCH) formulas on fill -- You are receiving this

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #5 from Peter --- Created attachment 178985 --> https://bugs.documentfoundation.org/attachment.cgi?id=178985&action=edit Screen Shot of DEMO spreadsheet Saving Sometimes saving task 30 seconds and libreoffice stops respondi

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #4 from Peter --- Created attachment 178984 --> https://bugs.documentfoundation.org/attachment.cgi?id=178984&action=edit Apple Crash Report - 2.5 MB Spreadsheet In normal (i.e. not safe mode) after 2.5MB spreadsheet hang an

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #3 from Peter --- Created attachment 178983 --> https://bugs.documentfoundation.org/attachment.cgi?id=178983&action=edit Apple Crash Report - Demo Spreadsheet Memory Exponential increase In normal (i.e. not safe mode) after

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 Peter changed: What|Removed |Added Attachment #178981|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 148094] Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING

https://bugs.documentfoundation.org/show_bug.cgi?id=148094 --- Comment #1 from Peter --- Created attachment 178981 --> https://bugs.documentfoundation.org/attachment.cgi?id=178981&action=edit Demonstration Spreadsheet This spreadsheet contains the INDEX(range,MATCH(1, ("X"=range) * ("Y"=range)