Bug 38721 - cannot open spreadsheet with matrix formular's
Summary: cannot open spreadsheet with matrix formular's
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.1 RC2
Hardware: All Windows (All)
: high major
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.5
Keywords: perf
Depends on:
Blocks:
 
Reported: 2011-06-27 10:00 UTC by Oliver Brinzing
Modified: 2015-12-15 11:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
test_performance_matrix (82.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-06-27 10:00 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Brinzing 2011-06-27 10:00:45 UTC
Created attachment 48476 [details]
test_performance_matrix

try to open attachend spreadsheet.
it contains only some matrix formulars

btw: no problem with oo 3.2/3.3/3.4
Comment 1 Markus Mohrhard 2011-06-30 12:58:25 UTC
can you give some more details about what is happening?
do you have a crash or do you get a error message? or even worse does the progress bar just freezes?

I can open it with a build from master but might have some hints for a deadlock in mdds.
Comment 2 Oliver Brinzing 2011-07-01 10:04:39 UTC
> can you give some more details about what is happening?

lo starts loading and will freeze at "adapt row height"
cpu usafge is 50% and memory consumption goes up.

btw: if you try with oo34beta1 please have a look at:
        http://openoffice.org/bugzilla/show_bug.cgi?id=118218
Comment 3 Markus Mohrhard 2011-07-01 15:48:43 UTC
Kohei, I think this is something for you. I have a similar problem with 3.4 but as soon as I attach gdb the problem is gone and I end up in a pthread method that seems to lock.

It might be related to https://bugs.freedesktop.org/show_bug.cgi?id=38028 but I noticed that in this case the destructor of ScMatrix caused some problems too.
Comment 4 Kohei Yoshida 2011-07-11 21:20:16 UTC
Addressing Bug 38028 has improved the load performance of this document as well.  But there is still a slight bottleneck in there, so I'll take a deeper look at that to see if that's solvable.
Comment 5 Kohei Yoshida 2011-07-13 08:32:19 UTC
Unfortunately this one appears to have a different bottleneck than Bug 38028, and I'm not sure if I can fix this in the 3.4.x branch to be honest.
Comment 6 Kohei Yoshida 2011-07-14 07:54:50 UTC
Re-targeting to 3.5.  As far as I can tell from my callgrind output this is not something caused by the matrix rework.
Comment 7 rim 2011-07-14 08:18:31 UTC
First of all - I'm very positive about LibreOffice, version 3.3.x and not in the least: Calc.

I'm using several sheets - some very large with matrix calculations - and that works fine with 3.3(.3).
Unfortunately something went wrong with 3.4 (loading those sheets freezes LO) and postponing a solution to 3.5 would imho be a serious mistake: "LibreOffice 3.4.2, available at the end of July, will target enterprise deployments."...?!
Comment 8 Kohei Yoshida 2011-07-14 08:33:35 UTC
rim, this is not the place for you to add rant. If you don't have any useful input to the bug, please don't add any useless blurb.

If you can provide a test document, please open a new bug and attach the test document there.  Otherwise you are not helping us.
Comment 9 rim 2011-07-14 08:43:48 UTC
sorry, my comment was not in any way meant to be abusive: I was just trying to emphasize the importance of a timely fix! 'Rant' and 'blurb' sounds rather hostile and I think this isn't the place for that either.
I need time to remove personal data from my sheets before I can post them here - I'll see what I can do to help.
Comment 10 Kohei Yoshida 2011-11-22 12:08:51 UTC
Ok.  Fixing Bug 40990 also fixed this.  I guess it was caused by the same root issue.

The fix should appear in 3.5, or the next daily master build.
Comment 11 Robinson Tryon (qubit) 2015-12-15 11:40:40 UTC
Migrating Whiteboard tags to Keywords: (perf)
[NinjaEdit]