https://bugs.freedesktop.org/show_bug.cgi?id=79288
Priority: medium
Bug ID: 79288
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: LibreOffice Calc / Spreadsheet .ods format very slow
when saving
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: francew...@ubertus.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: Spreadsheet
Product: LibreOffice
Issue: LibreOffice Calc/Spreadsheet is very slow when saving to ".ods" file
type. It takes 10 to 40 seconds on each save. Depending on the size of the
spreadsheet. The amount of text in the cell is directly correlated to the
length of time required to save the spreadsheet.
Steps to reproduce
1. Create a fresh new calc document
2. Type in any plain text in cells, at least 512 characters
3. Copy then paste that cell at least 50 times into new cells. For a total of
50+ cells.
4. Copy that sheet at least 10 times into new sheets. For a total of 11+
sheets.
5. Click on "Save" button. Select ".ods" file type. It takes 10 to 40 seconds
to save depending on spreadsheet size.
6. Make a small change like changing only one character inside one cell. Click
on "Save" button. It takes 10 to 40 seconds on each save.
7. I usually work with 30+ spreadsheets open at once, frequently making small
changes and frequently saving. LibreOffice 4.1.4 is painfully slow when saving
to ".ods" file type. Expected result is improve performance on saves. Loading a
document is very fast though.
Using:
* LibreOffice 4.1.4, 64 bit
* Debian 7.5 (wheezy) 64-bit
* Kernel Linux 3.2.0-4-amd64
* GNOME 3.4.2
* Memory: 16 GB
* Processor: Intel Core i7-3770S, 3.10 GHZ, 8 CPU activated
* Storage: Solid State Disk (SSD)
* Notes
** Fresh new computer install
** All hardware are 2013 or 2014
** LibreOffice is the only software open
** Calc document contains only plain text, nothing else, no graphic, no text
formatting, no color, no nothing else than plain text
** LibreOffice was install from the Official Debian repository:
"libreoffice-gnome-1:4.1.4-2~bpo70+1 (64-bit)", maintainer: Debian LibreOffice
Maintainers <debian-openoff...@lists.debian.org>
Things I tried but with same slow save result
* Using other computers
* Re-installing LibreOffice
* Increase memory to maximum allowed by LibreOffice. Under "Options > Load/Save
> General"
* Save spreadsheet in other LibreOffice formats, such as ".fods"
Thing I tried that resulted in huge performance improvement
* Save in Microsoft format ".xlsx". Very fast performance, down from 40 seconds
to 1 second or less. But this is just a temporary workaround. I would prefer
using ".ods" format because: it's the default format for LibreOffice; it's open
source; and own by a community not own by a corporation.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
