This is the report of the same regression problem as in Bug 54638 but with respect to the export function. Comments in Bug 54638 indicate that everyone is having performance problems both with opening and saving ods files. How to reproduce the problem: 1. create a new spreadsheet 2. enter a 10 lines long multiline text into cell A1 containing the word "libreoffice" in all lines 3. copy/paste A1 to B1:N1 4. copy/paste row 1 to row 1-100 You will have a spreadsheet of 14x100 cells containing the same multiline text. Now, saving the spreadsheet takes 2 secs in LO3.4 33 secs in LO3.6
As the creator of the related and today fixed bug Bug 54638, I also request to continue as was mentioned https://bugs.freedesktop.org/show_bug.cgi?id=54638#c14
Have just upgraded from the 3.6.* up to latest 4.* , and the saving now takes a lot more time than ever before. While before, with 3.6.*, it took me to save my data about 2-4 minutes. Now with 4.*, it might be 15-20 minutes!!! Horrible!
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=21661ebfbec9ea162582bbc7ab46607eb9095f1a fdo#60740: Populate auto styles from edit cells without using UNO API. 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.
This is now fixed. The speed of ods export in this specific use case should be much quicker in 4.2.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=882bee5ede38b6ed4e1ec870d835546868c6586d fdo#60740: Export edit cells to ods without using UNO API. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d81b56c7f679477fed471f8150e1b95e6902e249 fdo#60740: Handle empty paragraphs correctly. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a8bf709911f84492624d8ebb12cb0d92bc2ee730 fdo#60740: Export cell field items without using UNO API. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d5d96b15551fb685a99a4ee4217a152e00bc0dbf fdo#60740: Export multi-line formula results to ods without UNO API. 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.
Blogged about it: http://kohei.us/2013/08/26/speedier-export-of-rich-text-cells/
Impressive! I've tested it from the daily builds and in the VM so far only, but the save/export performance seemed to be bit more effective than your other load/import fix in Bug 54638. Thanks!!!
Migrating Whiteboard tags to Keywords: (perf) [NinjaEdit]