Bug 44420

Summary: FILEOPEN: when trying to open an ods file (created in open office) with matrix formula, libreoffice says adapting row height, then eats up all memory (1GB) on my system and the whole system freezes
Product: LibreOffice Reporter: walter keller <wa>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: oliver.brinzing, robinson.libreoffice
Priority: medium Keywords: perf
Version: 3.4.4 release   
Hardware: Other   
OS: All   
Whiteboard: BSA target:3.5
Crash report or crash signature: Regression By:
Attachments: this is an example of such a file
test vlookup/matrix formulars

Description walter keller 2012-01-03 04:33:20 UTC
Created attachment 55078 [details]
this is an example of such a file

Problem description: 

Steps to reproduce:
1. .... open the attached file
2. .... ==> on the same computer with Windows and openOffice the document is opened and I can work normally in it, 
3. ....

Current behavior:

Expected behavior:

Platform (if different from the browser): linux ubuntu
              
Browser: Mozilla/5.0 (Ubuntu; X11; Linux i686; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
Comment 1 Markus Mohrhard 2012-01-03 04:43:07 UTC
In this step Libreoffice calculates the result of all cells in the first sheet which might take some time with a lot of matrix formulas.

It is a known problem that we need too much time calculating the result but we have already a bug report for that.
Comment 2 walter keller 2012-01-03 05:03:03 UTC
(In reply to comment #1)
> In this step Libreoffice calculates the result of all cells in the first sheet
> which might take some time with a lot of matrix formulas.
> 
> It is a known problem that we need too much time calculating the result but we
> have already a bug report for that.


Hello 

I know that it is taking long - but on Ubuntu it is freezing the whole system - the only thing you can do is switch off the power and I have the probleme for nearly since spring 11 (probably since Ubuntu changed to libreOffice) ==> are you sure this is the same problem?
Comment 3 Oliver Brinzing 2012-01-07 05:09:17 UTC
Created attachment 55263 [details]
test vlookup/matrix formulars
Comment 4 Oliver Brinzing 2012-01-07 05:12:17 UTC
added another file lo3.4.4 refuses to open

btw: the file can be opened with oo3.4m1 but will freeze if one enters a value in 
        column c which does not exist in column a (e.g. 0 or 2501).
Comment 5 Kohei Yoshida 2012-07-18 06:27:28 UTC
I can no longer reproduce this using 3.5 and later releases.
Comment 6 Kohei Yoshida 2012-07-18 22:02:54 UTC
In any way I slice it, I can't reproduce this hang or memory issue using 3.5 and later.  I'll mark this bug fixed.  Please try at least the latest stable 3.5 or later.

For the record, I do remember fixing a bug very similar to this one during the 3.5 cycle.
Comment 7 Robinson Tryon (qubit) 2015-12-15 11:16:50 UTC
Migrating Whiteboard tags to Keywords: (perf)
[NinjaEdit]