Bug 154830 - Fileopen takes too long to open an existing small file when network printer not available
Summary: Fileopen takes too long to open an existing small file when network printer n...
Status: RESOLVED DUPLICATE of bug 42673
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-15 17:25 UTC by Dennis
Modified: 2023-04-22 08:06 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
This is a file I just created and it takes over 30 seconds to open. (7.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-04-17 15:05 UTC, Dennis Wage
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis 2023-04-15 17:25:52 UTC
fileopen takes more than one minute to open an existing file. I go to another program and use it while I am waiting. This occurs in both Windows 10 and 11.
Comment 1 Mike Kaganski 2023-04-15 21:25:00 UTC
Likely bug 42673.
Comment 2 Rainer Bielefeld Retired 2023-04-16 06:06:29 UTC
@reporter:
without a sample document this report is rather useless.
Comment 3 Dennis Wage 2023-04-17 15:02:52 UTC
This is also happening to me. The only thing different is that Windows 11 as of 2 days ago updated to 2023-04 Cumulative Update for Windows 11 Version 22H2 for x64-based Systems (KB5025239).

1. If I open Calc and attempt to open an .ods file it takes between 30 seconds and a minute to open.

I had success one time creating a new .ods file. It did at first open quickly. But now it doesn't.

I did find that once a file is open then either left open or closed, others then load quickly as they should.

DW
Comment 4 Dennis Wage 2023-04-17 15:05:57 UTC
Created attachment 186731 [details]
This is a file I just created and it takes over 30 seconds to open.

Attached ods file just created that takes over 30 seconds to open. Once it is open however, all other files open quickly. It's only the first file that is a problem.
DW
Comment 5 Dennis Wage 2023-04-17 15:11:44 UTC
It's not just Calc either. Writer is doing the same thing.
Comment 6 Rainer Bielefeld Retired 2023-04-17 15:15:22 UTC
NOT reproducible with reporter's sample document and Installation of Version: 7.5.0.1 (X86_64)  
Build ID: 77cd3d7ad4445740a0c6cf977992dafd8ebad8df
CPU threads: 12; OS: Windows 10.0 Build 19044; 
UI render: default; VCL: win – Locale: de-DE (de_DE); UI: de-DE
Calc: threaded |  Elementary (SVG)  Theme  |  Normal UserProfile 

File opens within fraction of a second

@reporter / Dennis Wage
a) What is your result in safe mode or even better with a newly created user profile? 
b) Please contribute more complete information concerning your LibO as you see above!
Comment 7 m_a_riosv 2023-04-17 23:53:47 UTC
No delay
Version: 7.5.3.1 (X86_64) / LibreOffice Community
Build ID: d29ee673721b12c92b3de9b9663473211414f0db
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Maybe some network printer installed, not available.
Comment 8 Dennis 2023-04-18 16:39:05 UTC
When a calc file in the LibreOffice file list is clicked to open it, not only does the file not open immediately, but LibreOffice freezes as well, so that the window cannot be minimized. Another application window must be opened on top of it to get other work done while waiting for the file to open.

Once the first calc file does open, others open immediately as long as LibreOffice is open. If LibreOffice is closed, the problem starts all over again.
Comment 9 ady 2023-04-18 19:40:40 UTC
@Dennis, what about the question from comment 7?
> Maybe some network printer installed, not available.
Comment 10 Dennis 2023-04-18 22:05:42 UTC
It is true I have a laser printer that is not turned on. However, LibreOffice Writer (latest version of LO) does not have a problem with this, nor does any other application outside of LibreOffice. 
Writer used to have a problem on earlier editions, but it was fixed.
Comment 11 QA Administrators 2023-04-19 03:24:26 UTC Comment hidden (obsolete)
Comment 12 Dennis Wage 2023-04-20 17:15:00 UTC
(In reply to ady from comment #9)
> @Dennis, what about the question from comment 7?
> > Maybe some network printer installed, not available.

Yes, I just fixed it. It was an unavailable printer. But, my question is why?
Comment 13 Mike Kaganski 2023-04-22 08:06:13 UTC
(In reply to Dennis Wage from comment #5)
> It's not just Calc either. Writer is doing the same thing.

(In reply to Dennis from comment #10)
> It is true I have a laser printer that is not turned on. However,
> LibreOffice Writer (latest version of LO) does not have a problem with this,
> nor does any other application outside of LibreOffice. 
> Writer used to have a problem on earlier editions, but it was fixed.

(In reply to Dennis Wage from comment #12)
> It was an unavailable printer. But, my question is why?

Dennis: you might notice that Dennis Wage continues to have this problem with Writer, too. No, it was not fixed, it's just you don't see this problem with your current *documents* or *system setup*.

Dennis Wage: the "why" is because LibreOffice uses the information *reported by printer driver* for some things; e.g., for pagination in Calc. Unfortunately, obtaining this information is not done "in background", but rather, the program waits until the information is returned. Whenever the printer driver needs some time to either communicate with printer, or to discover that the printer is unavailable, that timeout "hangs" LibreOffice.

When does this happen? When the printer *used by the current document* is unavailable. Two options here: either the current document does not have a specific printer configured, and then *the system default printer is used*, and that happens to be unavailable - in this case, people would tend to see this hang almost independently of the document; or the current document has a specific (non-default) printer configured, which happens to be unavailable. In this latter case, only specific documents would suffer; and in this case, the option to not apply the printer configuration from the document would help (unlike the former case). But the underlying problem is the same.

Yes this is a bug, I do not say that it's OK. I only explain the status quo.

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