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

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 7.0.3.1 (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 6.4.6.2, the same file in either .ODS or .XLSX format loads in about 3 seconds.

Houston, I think we have a problem.

C:\fakepath\LO-IMDB.odt

edit retag 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.

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

Done, as I imagine you can see.

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

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

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

Instantly also with Win10 LO 6.4.7

( 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

C:\Windows\System32\DriverStore\FileRepository\prnms012.inf_amd64_707d3849370b9d23\Amd64\MSIPP-manifest.ini

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.

( 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.

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

( 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?

( 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.

( 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

( 2021-02-10 04:48:42 +0200 )edit