Created attachment 143289 [details]
Example file from Excel with too many cell styles
Attached xlsx file was made by a user in Excel and contains tens of thousands of cell styles [I have no idea how or why did they do this :)].
Opening this file or even the Cell styles list in Excel takes only a few seconds, but in current Calc it takes several minutes.
It would be nice if we could open it quickly.
26.5% memory and 8 seconds to open the spreadsheet
old laptop dell latitude D620, 1 Gig ram, dual cpu, about ten year old
Build ID: 7696d1d217b6cff63490e7f98403d0e499c33d17
CPU threads: 2; OS: Linux 4.14; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-06-30_03:32:29
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Sorry, I forgot to add: to experience the slowdown, you need to open the Styles sidebar deck in Calc.
Confirmed on ubuntu 16.04 x64 with Version: 126.96.36.199.alpha0+
Build ID: 757d9e43315755869af30e79c0457fd529cb050a
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-06-26_02:55:47
Locale: en-US (en_US.UTF-8); Calc: threaded
and with Version: 188.8.131.52
Build ID: 07ac168c60a517dba0f0d7bc7540f5afa45f0909
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: en-US (en_US.UTF-8); Calc: single
Also reproduced in
Version 184.108.40.206.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
it takes forever to open...
On pc Debian x86-64 with master sources updated today, I don't reproduce this but had this:
"The data could not be loaded completely because the maximum number of columns per sheet was exceeded."
The original problem is no longer reproducible.
1. Now the warning is displayed.
2. The was a performance issues showing the styles sidebar. Before https://cgit.freedesktop.org/libreoffice/core/commit/?id=86ab2b2fcd95c6d14d0fd91dd1adaee5e7fd5713 it takes 3 minutes 10 seconds for me, after the commit it takes 10 seconds.
(In reply to Gabor Kelemen from comment #2)
> Sorry, I forgot to add: to experience the slowdown, you need to open the
> Styles sidebar deck in Calc.
Ok, then it's a dupe of bug 126663
*** This bug has been marked as a duplicate of bug 126663 ***