Created attachment 127685 [details] pivot tables with groups The attached xlsx file takes a lot time to import. (I waited 20 minutes before shut down the application.) My computer parameters are: Intel i7-6700 CPU, 16GB RAM, SSD. The expected import time is less than a minute. The issue is related to the groups of the pivot tables. All pivot tables in the test document have the same source range and so share the same groups.
A fix was added to master: https://cgit.freedesktop.org/libreoffice/core/commit/?id=3b64a198568d5b2bb14066581aca112cc6182fd7 With that codechange import time is less than a minute.
Tamás Zolnai committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=03a1143cc75161dab56b20f1ab9e723ddd0caa8e tdf#102694, bnc#957991: Improve pivot cache reading performance It will be available in 5.3.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.
Congrats on the fix. 20 minutes to half a minute is a huge improvement. http://zolnaitamas.blogspot.ae/2016/10/improving-pivot-table-import.html Added it to the release notes. https://wiki.documentfoundation.org/ReleaseNotes/5.3#Improvements_in_OpenXML_filter
Tamás Zolnai committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=29999ea70626a4b1dd312ad6e07f1131b6449f93&h=libreoffice-5-2 tdf#102694, bnc#957991: Improve pivot cache reading performance It will be available in 5.2.4. 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.
*** Bug 89264 has been marked as a duplicate of this bug. ***