Bug 150979 - FILEOPEN: ods, opg, opd files open very slowly after startup on Windows
Summary: FILEOPEN: ods, opg, opd files open very slowly after startup on Windows
Status: RESOLVED DUPLICATE of bug 42673
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0 all versions
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-15 16:17 UTC by Thomas Passin
Modified: 2022-09-16 14:55 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Passin 2022-09-15 16:17:27 UTC
Description:
A tiny file -spreadsheet, Impress, or Draw - takes 30 - 40 seconds to open the first time after LO has been restarted.  This is only on Windows; the same file opened immediately on a Linux Mint VM. An .xlsx version of the same tiny file opens immediately after startup.  Even if the .xlsx version was opened first, the .ods file still takes that 30 - 40 seconds to open. Once the .ods file has been opened, then the .odg and .odp documents open immediately.

Writer files do not show this behavior.

I am reporting this for V7.4.1.2 but it goes back many versions.

Steps to Reproduce:
1.Open Calc, type "this is a test" into cell A1. (The actual behavior occurs for any spreadsheet).
2.Save as open-test.ods, then as open-test.xslx.
3.Close LO. 
4. Start Calc. Open open-test.xslx.  Observe immediate opening.
5. Open open-test.ods.  Observe very slow opening.

Actual Results:
The open-test.ods file takes 30 - 40 seconds (by counting, not a timer) to open even though it has only a short string in only one cell.

Expected Results:
The test-open.ods file should have opened immediately.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Note that if you close test-open.ods and then re-open it, it loads immediately.  The slow opening occurs only the first time after restart.  It is not necessary to first open the test-open.xslx file to demonstrate the behavior, but doing so narrows down the cause to something specific to LO files.

Create similarly tiny Draw and Impress files, and repeat the same steps, each time closing and restarting LO.  Note that I do not preload LO.

Turning Skia on and off did not cure the behavior.  Without Skia, opening test-open.ods seemed to take even longer.

There is no option to disable OpenGL in the Tools/View options.
Comment 1 Timur 2022-09-16 13:48:48 UTC Comment hidden (obsolete)
Comment 2 Thomas Passin 2022-09-16 14:18:25 UTC
(In reply to Timur from comment #1)
> Do you have some installed printer disconnected, not available?

Yes, my networked printer (the only one on the system) is usually powered down.  I just tried to open the example file with the printer powered and awake, and the open time dropped from 30 - 40 seconds to 4 - 7 seconds.

So that's better, but I don't think I should need to remember that the printer has to be on.  And if it's sleeping, I presume the opening delay will be longer.  Also, remember that .xslx files don't incur the delay.
Comment 3 Thomas Passin 2022-09-16 14:32:17 UTC
(In reply to Thomas Passin from comment #2)
> (In reply to Timur from comment #1)
> > Do you have some installed printer disconnected, not available?
> 
> Yes, my networked printer (the only one on the system) is usually powered
> down.  I just tried to open the example file with the printer powered and
> awake, and the open time dropped from 30 - 40 seconds to 4 - 7 seconds.
> 
> So that's better, but I don't think I should need to remember that the
> printer has to be on.  And if it's sleeping, I presume the opening delay
> will be longer.  Also, remember that .xslx files don't incur the delay.

Update - My printer just went to sleep so I tried opening the test file again and it still opened in the range of 4 - 7 seconds.
Comment 4 Timur 2022-09-16 14:55:25 UTC

*** This bug has been marked as a duplicate of bug 42673 ***