https://bugs.documentfoundation.org/show_bug.cgi?id=161372
Bug ID: 161372
Summary: Spreadsheets with comments are unreasonably slow
Product: LibreOffice
Version: 24.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 194506
--> https://bugs.documentfoundation.org/attachment.cgi?id=194506&action=edit
File with lots of comments to demonstrate speed problems
I use lots of very large Calc files (20MB+) and the speed is reasonable.
However, if the file has lots of comments, the program gets extremely slow even
for very small files.
I attach a file about 160kB. It has two sheets, both 100x100 cells used. No
formula, just plain text. The only difference is that the first sheet has no
comments, while in the second every cell has one.
Now e.g. try to select columns A and B and right mouse Delete Columns. As there
are no formulas, this should be a very simple operation. In the "nocomments"
sheet it is instant as expected, while in the "comments" sheet it is about 2
minutes! Even closing the file takes more than 15 seconds without saving!
Although it is "just a performance issue", I find it a bug. It seems something
is wrong/inefficient in the comment handling deep inside.
Remarks:
(I found some similar bugs (123417, 123418), but those are typically larger
files. This is simple, still very slow.)
(Originally I generated the file with a third party tool and it was less than
100kB. However I do not want the error to be linked to that tool, so I opened
the file and saved it with Calc itself - that is another question why the size
then increased more than 60%?)
--
You are receiving this mail because:
You are the assignee for the bug.
