Created attachment 113629 [details] xlsx pivot tables "General Error. General input/output error." when opening an XLSX file on Windows with several pivot table reports(both 32 and 64 bit versions of windows tested) Tried LibreOffice stable 4.3.2.2 AND 4.4.0.3 Might be a regression of https://bugs.documentfoundation.org/show_bug.cgi?id=57732
With Version: 4.5.0.0.alpha0+ Build ID: 52fa2e97dfef1a5f27aaee6af7ed80800641b86c TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-02-22_01:03:18 LO crashes when opening this file. I can open file without problem in excel2010.
Created attachment 113631 [details] gdbtrace
So I've posted a fix for the crash (abort, strictly speaking, but from user's perspective, it's the same) for a code review. But it doesn't help OP much, as this particular document then still takes some 20+ minutes to open (on my slow-ish laptop)
Katarina Behrens committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=529e9b61171f3155a76fe68e3019f5f3eb23bc4e tdf#89597: Resize formula buffers after adding a dummy sheet It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fix Validated on libo-master~2015-03-26_01.49.14_LibreOfficeDev_4.5.0.0.alpha0_Win_x86, works on my laptop too (took around 5mins to open and the data was there)
Katarina Behrens committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ecef42a18b9efee3f0430cb00f02f241446b44a7&h=libreoffice-4-4 tdf#89597: Resize formula buffers after adding a dummy sheet It will be available in 4.4.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
... which makes this fixed for 4.5 and 4.4.3
It worked fine with 4.2.0-beta, and started somewhere in 4.2.0.x, so I change version to 4.2.0.4. Thank you for writing about the possibility of backporting to 4.3.
> Thank you for writing about the possibility of backporting to 4.3. Hm hm, is it really so annoying bug that it's worth backporting? I might try, but in a week we have the latest 4.3 bugfix release ...
Well, the latest 4.3 bugfix release will be (in my case and many conscious users) used for the next 6 months, so it would be fine to have all relevant bugs fixed. Fine doesn't mean necessary, so please decide in accordance with your time. But in this case, there's another issue: as you noticed, opening the file on 4.5.0-dev is much slower then on 4.1.6. I think that should be another bug.
> But in this case, there's another issue: as you noticed, opening the file on > 4.5.0-dev is much slower then on 4.1.6. I think that should be another bug. It is - bug 90129
Katarina Behrens committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=589f7cbe3789224a8836f3cd4705f067be6789c5&h=libreoffice-4-3 tdf#89597: Resize formula buffers after adding a dummy sheet It will be available in 4.3.8. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Katarina Behrens committed a patch related to this issue. It has been pushed to "libreoffice-4-3-7": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c630c9e6eb90f8f2d29be7fe12646835d6af8076&h=libreoffice-4-3-7 tdf#89597: Resize formula buffers after adding a dummy sheet It will be available in 4.3.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.