I have a spreadsheet with about 300 sheets and each sheet contains some data and formula calculating the mean and the standard deviation of the data. It takes about 25-30 seconds to save the file every time, even after a minor change of a cell. I am using LibreOffice 4.2.7.2 on Ubuntu 14.04. If I convert the same file into MS Excel .xlsx format then open it in MS Office in Windows, the file can be saved instantly after a minor change.
I updated my LibreOffice via Launchpad PPA to 4.4.2.2, but the issue still exists. I was wondering if the formula of calculating mean and standard deviation in each sheet causes the slow file save.
Actually, the upgrade to 4.4.2.2 seems to have fixed the issue. However, the first time when LibreOffice saves the file, it still takes about 25-30 seconds, but after that the file is saved almost instantly.
I think I jumped the gun by saying the issue was fixed by the upgrade. The issue still exists. After I added another sheet, the file save issue came back. Sorry.
Hello Jeffrey, Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 114869 [details] Test file for FILESAVE
Here are the steps to replicate the issue: 1. Open the attached file with Calc 2. Go to the last sheet "Test 294" and right-click it and choose "Move/Copy Sheet", then choose "Copy". Name the new sheet, say "Test 295". 3. Save the file. It will take about 25-30 seconds to finish. Hope this helps.
I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 51e0d789c344547956764c3b5f0ef5a304f4e0aa TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-13_16:58:45 excel save < 1 sec, LO save ~20 sec (i5, 6GB RAM, SSD)
Migrating Whiteboard tags to Keywords: (perf)
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=44c1cfc7d8ab7afb1e01ac57d3feeb410ba43748 no need to call rowHidden and rowFiltered repeatedly, tdf#90659 It will be available in 5.2.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.
*** Bug 82923 has been marked as a duplicate of this bug. ***