[Libreoffice-bugs] [Bug 40568] PIVOTTABLE: Crash FILEOPEN of EDITING complex documents

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40568

--- Comment #6 from andis.lazdins at gmail.com 2011-09-06 22:37:09 PDT ---
(In reply to comment #5)
> @andis.lazdins at gmail.com
> Can you try to reduce the sample a little? what if the hidden PT is the reason?

Fantastic!!!
As soon as I unhide the hidden sheet in sample document, libreoffice 3.4.3
could open the document; however it stopped responding in a few seconds and
crashed with 100% utilization of CPU.

After removing all pivot tables file opened much faster, but it stopped
responding on adapt row height in a few seconds and crashed afterwards with the
same 100% CPU utilization.

After I removed spreadsheet containing complex array formulas in the file with
previously removed pivot tables opened normally.

It seems that the problem is not in pivot table problem (I'm sorry to
developers), but formula recalculation problem. Unfortunately I don't have any
file with lot of pivot tables based directly on raw data. However, rather big
spreadsheet (10 MB) with single pivot table opened very well with libreoffice
3.4.3.

You can use the same sample file to identify reason of crashes, however, there
is no need to concentrate on pivot tables, at least for this reason, anymore.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.