Created attachment 47880 [details] Sample file with pivot table Opening some xls files with pivot tables causes crash of Libreoffice 3.4. Openoffice 2.4.2 open those files without problems, however, pivot tables are broken. Sample file follows in attachment.
Created attachment 47884 [details] mso behavior to open the xls.
Reproduced on 3.4 build on SLED 11 sp2. MSO doesn't not open this file successfully either, but it doesn't crash. It looks like to be caused by the 'merged' head cells are not valid as pivot table field name? Please see the screenshot to see how MSO complaint this file. cc for Kohei's review.
Hi! Yes, Excel also complains this file, in spite it is created by Excel XP. It is not the first example. I found that Libreoffice 3.4 crashes also on files containing pivot tables and created by Libreoffice 3.3. I'll try to find an example, which do not contain classified information. The most important is that Openoffice.org 2.4.2 do not crash. Only pivot table is corrupted. This means I can access data through Openoffice 2.4.2. That would be normal behavior also for Libreoffice 3.4. Returning to libreoffice 3.3 is not an option, because of very serious regressions in data pilot function.
I tried to open files previously created by Openoffice.org 3.x or libreoffice 3.x and containing several (tens of) pivot tables. The most of them crashes during open with response: terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc Ubuntu 10.10, libreoffice 3.4 No errors in Openoffice.org 2.4.2 Didn't try with newer versions. I'm sure it's very serious regression. For some strange reason pivot table or data pilot function becomes worse and worse with every libreoffice / openoffice.org version. Taking in account that it is the only feature making those suites comparable with excel, it is very careless attitude to quality.
Kohei, please could you look at this crash?
The problem still exist in 3.4.1. Files created in previous versions of Openoffice.org or Libreoffice and containing several (tens of) pivot tables causes crash of Libreoffice 3.4.1 on refreshing pivot tables. Consumption of CPU during this time and after crash of Libreoffice reaches 100 %. In Libroffice 3.3.3 the same files doesn't cause any visible fluctuations of CPU consumption during the refresh.
Libreoffice 3.4.2 still crashes on complex documents containing a lot of pivot tables created in previous versions of libreoffice. It makes impossible use of libreoffice 3.4 branch up to recent version for complex calculations and data analysis. I could provide sample file to developers willing to work on this regression, however I don't want to make it public. Best regards!
It seems to be solved in 3.4.4, the document can be opened, however, pivot table should be rebuild.