Bug 44420 - 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
Summary: FILEOPEN: when trying to open an ods file (created in open office) with matri...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA target:3.5
Keywords: perf
Depends on:
Blocks:
 
Reported: 2012-01-03 04:33 UTC by walter keller
Modified: 2015-12-15 11:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
this is an example of such a file (48.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-03 04:33 UTC, walter keller 		Details
test vlookup/matrix formulars (82.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-07 05:09 UTC, Oliver Brinzing 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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]