Calc: Simple .ODS file loads slowly under LO 7, .XLSX fast

asked 2021-02-08 10:56:40 +0200

djc gravatar image

updated 2021-02-08 15:30:27 +0200

There are questions here already about slow loading times for Calc files, but it may be useful to add this one, with some additional data.

I have a simple 254KB .ODS file of IMDB data -- text with no calculation -- comprising these six sheets in these dimensions:

A: 2342 rows by 12 columns
B: 308 x 13
C: 478 x 13
D: 736 x 13
E: 64 x 6
F: 310 x 5

On a desktop system (Win10, Intel i7, 3.4 GHz, 16GB), since installing LO (x64) this file takes approximately 15 seconds to load, during which the window is completely blank except for the outline of the LO icon in the upper left and the Windows actions in the upper right.

The same file, converted with LO Calc to MS Office 365 .XLSX, loads in about 1 second.

On a much older, slower laptop system (Linux Mint 20.1, Intel Core2 Duo, 2.3 GHz, 4GB) with LO, the same file in either .ODS or .XLSX format loads in about 3 seconds.

Houston, I think we have a problem.


edit retag flag offensive close merge delete


Can you attach the file to your question (if it contains no private data as it seems) so that we can experiment?

Edit your question and use the "paperclip" tool.

ajlittoz gravatar imageajlittoz ( 2021-02-08 11:52:49 +0200 )edit

Done, as I imagine you can see.

djc gravatar imagedjc ( 2021-02-08 15:30:48 +0200 )edit

Opens quasi instantly on my Fedora 33 Linux box, KDE Plasma desktop, LO Hardware: Intel i5, 3.4GHz, 16GB

ajlittoz gravatar imageajlittoz ( 2021-02-08 15:54:44 +0200 )edit

Instantly also with Win10 LO 6.4.7

m.a.riosv gravatar imagem.a.riosv ( 2021-02-08 18:41:50 +0200 )edit

Using Sysinternals ProcMon, I see something on Windows that I simply can't interpret: soffice.bin starts up and does a lot of housekeeping for about 1.38 seconds ending with closing


then NOTHING for 12.02 seconds until it refers to the Registry, and about a second later takes a stab at the file. I wonder what's happening during that 12 seconds. Whatever it is, it's not soffice.bin that's doing it.

djc gravatar imagedjc ( 2021-02-09 01:47:09 +0200 )edit

This is not a solution to your problem but additional information. Either add it to the question by editing it or use the more link under this "non-answer" to repost as a comment.

Leaving this as an answer leads to think that the question is solved as seen from the home page and you may then not receive a definite answer as contributors could think it is already done.

ajlittoz gravatar imageajlittoz ( 2021-02-09 07:36:02 +0200 )edit

Please test with a clean profile Menu/Help/Restart in Safe Mode

m.a.riosv gravatar imagem.a.riosv ( 2021-02-09 09:17:14 +0200 )edit

I've just tried safe mode three different ways: "restore from backup", "configure", and "reset to factory settings". With all of those, Calc starts up 15%-20% slower than normally. Incidentally, my "answer" was poorly posted because it's obviously not an answer; I should have put it here. Is there some way to correct that?

djc gravatar imagedjc ( 2021-02-09 09:37:32 +0200 )edit

At the end of your "non-answer", there is a list of command links. One of these is more (only you as answer owner can see it). Click on it. A popup menu with "repost as comment" appears.

ajlittoz gravatar imageajlittoz ( 2021-02-09 09:50:48 +0200 )edit

I wonder if it is an anti virus program scanning on load "unfamiliar" ODS files but not known file types like XLSX

Earnest Al gravatar imageEarnest Al ( 2021-02-10 04:48:42 +0200 )edit