[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #43 from Markus Mohrhard --- (In reply to andis.lazdins from comment #42) > (In reply to Joel Madero from comment #41) > > Markus is one of our most experienced developers - closing. > > > >

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #42 from andis.lazd...@gmail.com --- (In reply to Joel Madero from comment #41) > Markus is one of our most experienced developers - closing. > > His point was that you were describing a separate issue from how this bug >

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 Joel Madero changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #40 from andis.lazd...@gmail.com --- (In reply to Markus Mohrhard from comment #39) > You are mixing many different problems into this bug report. I'm loosing the > overview what you are complaining about. The original report

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #39 from Markus Mohrhard --- (In reply to andis.lazdins from comment #38) > (In reply to Markus Mohrhard from comment #37) > > > From all the comments it seems that 5.1 is at least much better

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #38 from andis.lazd...@gmail.com --- (In reply to Markus Mohrhard from comment #37) > From all the comments it seems that 5.1 is at least much better than older > versions. Maybe not perfect but still better. I would not say

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #37 from Markus Mohrhard --- (In reply to Julien Nabet from comment #36) > (In reply to Markus Mohrhard from comment #34) > > Does this still happen in master. There were a few fixes to get the

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #36 from Julien Nabet --- (In reply to Markus Mohrhard from comment #34) > Does this still happen in master. There were a few fixes to get the memory > consumption in mdds under control and they are at

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #35 from andis.lazd...@gmail.com --- (In reply to Markus Mohrhard from comment #34) > Does this still happen in master. There were a few fixes to get the memory > consumption in mdds under control and they are at least in

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #34 from Markus Mohrhard --- Does this still happen in master. There were a few fixes to get the memory consumption in mdds under control and they are at least in current master, maybe also in

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #33 from andis.lazd...@gmail.com --- I got feeling that in 5.0.4 this problem is even worse. Calc stops responding for more than 5 minutes or crashes on array formula with 46000 records.Openoffice.org do it in few seconds. I

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 Robinson Tryon (qubit) changed: What|Removed |Added Keywords|

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #31 from Noel Grandin --- Running massif over this, points to the ScMatrix stuff (trimmed the MDDS stuff from the output): 99.29% (2,300,487,554B) (heap allocation functions) malloc/new/new[],

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.documentfoundation.org/show_bug.cgi?id=73049 --- Comment #30 from andis.lazd...@gmail.com --- Unfortunately the problem is still there in Libreoffice 4.4.0.3. Of course, we can use side by side libreoffice and openoffice for complex calculations, but it is not very convenient way of

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Matthew Francis fdb...@neosheffield.co.uk changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #29 from andis.lazd...@gmail.com --- (In reply to Matthew Francis from comment #28) Results from bibisect-43all: (Unsure if this is the only relevant performance regression, but the below is one significant transition from

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 raal r...@post.cz changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #27 from raal r...@post.cz --- unable to bibisect with bibisect-43all (git checkout oldest - LO3.5 freeze ) -- You are receiving this mail because: You are the assignee for the bug. ___

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #26 from andis.lazd...@gmail.com --- (In reply to comment #25) I tried to open the problematic file (https://drive.google.com/file/d/0Bxv4jQ_04jXZaVR2ZHZGR0JLVFE/ edit?usp=sharing) on 64 bit Lubuntu 14.04 loaded from USB stick.

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #25 from andis.lazd...@gmail.com --- I tried to open the problematic file (https://drive.google.com/file/d/0Bxv4jQ_04jXZaVR2ZHZGR0JLVFE/edit?usp=sharing) on 64 bit Lubuntu 14.04 loaded from USB stick. Loading time is a bit longer on

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #24 from andis.lazd...@gmail.com --- Ubuntu 13.10, Kernel 3.11-0-26-generic 64 bit, Mate 1.6.0 RAM 7.7 GiB Processor 4 x Intel(R) Core(TM) i3-3110M CPU @ 2.40 GHz Libreoffice 4.1.6.2 (used in production) 7 sec Libreoffice 4.3.1.2

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #18 from andis.lazd...@gmail.com --- If there are any hope to solve this and similar terrible Calc CPU use regressions or the only way is to move back to OpenOffice.org? Unfortunately it becomes worse with every next major releases

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added CC||er...@redhat.com,

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #21 from andis.lazd...@gmail.com --- (In reply to comment #20) (In reply to comment #18) [...] One example https://drive.google.com/file/d/0Bxv4jQ_04jXZRHZUeDlxSDRHNTQ/edit?usp=sharing With 4.2.6.3 it can be opened in 54

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #22 from Jean-Baptiste Faure jbfa...@libreoffice.org --- (In reply to comment #21) [...] The results mentioned in comment 18 are from Ubuntu 14.04, 32 bit, Kernel 3.13.0-32-generic, Memory 3.0 GiB, Processor 2 x Pentium(R)

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #23 from andis.lazd...@gmail.com --- (In reply to comment #22) It would be interesting if you could try with 64 bits versions of Ubuntu 14.04 and LibreOffice. Did you observe an heavy use of the swap when using LibreOffice ?

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #17 from andis.lazd...@gmail.com --- (In reply to comment #16) @Andis - can you provide the 7.9 meg file? Hello! Unfortunately that particular file contains classified information. I can send to you link to that file by e-mail

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #11 from andis.lazd...@gmail.com --- Hello! I tried in Libreoffice 4.3.1.2. It's impossible to open 7,9 MB calc file with libreoffice calc, if the file contains array or complex formula. The program just crash with: terminate called

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #12 from Joel Madero jmadero@gmail.com --- Do you think you could bibisect the bug? https://wiki.documentfoundation.org/QA/HowToBibisect That would help quite a bit. -- You are receiving this mail because: You are the assignee

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #13 from Julien Nabet serval2...@yahoo.fr --- Andis: just to be sure, did you rename your LO directory profile (as indicated in my previous comment)? You gave results but didn't confirm you had renamed it. -- You are receiving this

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #14 from andis.lazd...@gmail.com --- Hi! I tried it without installation by extraction using command for i in ../*.deb; do dpkg-deb -x $i . ; done and with it's own user directory [Bootstrap] BaseInstallation=${OOO_BASE_DIR}

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #15 from andis.lazd...@gmail.com --- (In reply to comment #12) Do you think you could bibisect the bug? https://wiki.documentfoundation.org/QA/HowToBibisect That would help quite a bit. I have 32 bit OS, not an option to me --

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #16 from Joel Madero jmadero@gmail.com --- @Andis - can you provide the 7.9 meg file? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #10

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #6 from andis.lazd...@gmail.com --- The problem persists in Libreoffice 4.2.6 It's really hopeless to open 10 MB Calc file (Ubuntu 14.04, 32 bit), in spite it can be opened and manipulated in Openoffice.org on the same computer. --

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #7 from andis.lazd...@gmail.com --- When I changed memory settings to default values in Openoffice.org, I was able to lead files and even do changes in Pivot tables. The default values are: Undo Number of steps - 100 Graphics cache

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #9 from andis.lazd...@gmail.com --- (In reply to comment #8) With 4.2.6 LO Debian package with i5 + 6GB, it gives: real 0m14.427s user 0m12.560s sys 0m0.820s with this command: time soffice --calc MPS\ Augsnes\

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Joel Madero jmadero@gmail.com changed: What|Removed |Added Whiteboard|perf|perf bibisectRequest

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Michael Stahl mst...@redhat.com changed: What|Removed |Added Whiteboard||perf -- You are

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added CC||serval2...@yahoo.fr

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 --- Comment #4 from Julien Nabet serval2...@yahoo.fr --- Created attachment 91370 -- https://bugs.freedesktop.org/attachment.cgi?id=91370action=edit valgrind trace Valgrind trace from file opening to its closing. -- You are receiving this

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Maxim Monastirsky momonas...@gmail.com changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 73049] FILEOPEN Huge memory use on opening specific complex ods spreadsheets with array functions

https://bugs.freedesktop.org/show_bug.cgi?id=73049 Markus Mohrhard markus.mohrh...@googlemail.com changed: What|Removed |Added Summary|FILEOPEN Calc crashes on|FILEOPEN