In case printer settings would be still a problem, you could try to uncheck Tools → Options → Load/Save → General, Load printer settings with the document.
4 Likes
@joshua4 :
Yes, it does (with other ods files). One more thing that might help, if a Calc file is already open, and I open a 2nd file, it doesn’t get the delay (the 2nd file opens immediately). So the delay happens only if there is not a Calc file already open, and happens every time.
If I load Calc with nothing, the blank sheet comes up immediately, no delay. It’s only after a file has been saved as ods that it happens. I just did that, merely putting “x” in A1 and saving the file, and the delay happens after closing the file and reopening.
One more data point: I had 3 Calc files open, and I opened a 4th, and noticed that this time, there was about a 3 second delay (blank, grey screen with “L” at top left), before the spreadsheet was displayed. In that spreadsheet there are only 4 sheets with info in rows and columns, no calculations.
Hrbrgr: I have no idea what your options/settings are. Are you starting from LibreOffice already open? Did you enable open LO on startup? Do you have any Calc files already open? If I have other Calc files open, I don’t get the delay.
@Hrbrgr:
There are no calculations in the sheet. That option says “open CL is not used.”
I tried resetting the profile by both the help wizard and manual, and neither worked.
“1. if you have specified a printer in your document that is switched off, delays may also occur. However, I do not know if this is LO version dependent” (7.1.8 very slow - #4 by Hrbrgr).
“I tried @ajlittoz’s suggestion, specifically Tools > Options > LibreOffice Writer > Print > Paper tray from printer settings. It was on, and I clicked it off. Since then, with the printer off, every spreadsheet I try opens immediately” (Calc: Simple .ODS file loads slowly under LO 7, .XLSX fast - #24 by djc).
@LeroyG , I don’t see an option to eliminate specifying a printer. Like I said, it is set to “Microsoft print as pdf.” Also, the options path you show doesn’t exist in my options menu. I already know that a specified printer turned off will incur delay. That is not the issue at hand.
LibreOffice Writer exists only if you have a Writer document open, and be it only an empty new document.
I tried every suggestion in this thread, but the problem still exists. This problem has become so annoying that I have established a work-around. I am converting all my spreadsheet files to xlsx, and will no longer use ods. So with the responses I have gotten (and no-response since), I take it that no one has any idea what causes this problem. So until I get a workable response, I will continue to work around this problem by not using ods format.
Other possibilities might be:
- In Tools > Options > LibreOffice Calc > General is
- *Update Links when Opening set to Always?
- Use printer metrics for text formatting ticked?
- In Tools > Options > LibreOffice Calc > Defaults is Enable very large spreadsheets ticked?
If you open Calc and then click Help > Restart in safe Mode > Continue in Safe Mode can you then open your spreadsheet quickly?
If so, then there might be an issue with your user profile. Consider resetting it, I prefer the manual method as I can then copy back the folders I need. Resetting user profile also returns the settings above back to their defaults of unticked.
Update Links when Opening set to Always?
No.
Use printer metrics for text formatting ticked?
No.
Enable very large spreadsheets ticked?
No such option shown
Continue in Safe Mode can you then open your spreadsheet quickly?
No, I already tried safe mode.
EarnestAl
July 4
Other possibilities might be:
- In Tools > Options > LibreOffice Calc > General is
- *Update Links when Opening set to Always?
- Use printer metrics for text formatting ticked?
- In Tools > Options > LibreOffice Calc > Defaults is Enable very large spreadsheets ticked?
If you open Calc and then click Help > Restart in safe Mode > Continue in Safe Mode can you then open your spreadsheet quickly?
If so, then there might be an issue with your user profile. Consider resetting it, I prefer the manual method as I can then copy back the folders I need. Resetting user profile also returns the settings above back to their defaults of unticked.
In that case look at your anti-virus scanning, possibly it gives a free pass to xlsx files but has to load itself to scan .ods. What are load times for xlsm like?
I turn off Windows File Indexing because of the huge resources it consumes. I instead rely on a simple file name search engine, Everything. Even with Indexer off, Windows File Explorer still occasionally makes me wait tens of seconds to display files in a directory. Possibly, Indexer takes the opportunity to index the contents of the .ods file during opening.
I don’t know what an xlsm file is. Do you have some theory as to why you think it may be anti-virus? It does not appear to me to be related. Nothing else has this issue, only the loading of the initial ods file.
EarnestAl
July 4
In that case look at your anti-virus scanning, possibly it gives a free pass to xlsx files but has to load itself to scan .ods. What are load times for xlsm like?
I turn off Windows File Indexing because of the huge resources it consumes. I instead rely on a simple file name search engine, Everything. Even with Indexer off, Windows File Explorer still occasionally makes me wait tens of seconds to display files in a directory. Possibly, Indexer takes the opportunity to index the contents of the .ods file during opening.
I am making suggestions. You have a problem that others don’t have; it doesn’t appear to be fixed in Safe Mode so probably the problem lies elsewhere.
I have had anti-virus software in the past that used to slow down loading of files. I do know that Indexer can slow things down a lot.
BTW xlsm is a macro-enabled Excel file likely to be of more interest to an anti malware program. You could see if xls take longer.
I have the same problem: first file opens late when network printer is offline. All other files open in time. It happens to any file, regardless the size, content or complexity.
It’s that simple.
Tried the above tips with no result.
Calc is a great application but this and the inability to set paper size in Tools-Options are the two problems beyond reason.
Sometimes, installing manufacturer’s printer driver rather than relying on the operating system printer driver can fix that.
Normally, setting a pdf printer as default printer prevents LibreOffice waiting for an offline printer to respond. What pdf printer did you use?
I have the official HP driver.
Since LO is the only application behaving like this, the logical conclusion is that the bug is in LO and there are no other, external, factors at fault.
It’s about the way LO deals with the environment, not the other way around.
LO should load the file, not “do some other thing” + load.
Page size is in the file/printer settings/properties (having HP printer driver).
I’ve abandoned the use of .ods, and all my calc files are .xlsx. However, my old computer got zapped by lightning, and my new computer with Win11 will open ods files quickly; it still shows grey screen, but it’s only about 1/2 second delay. The problem was on 2 computers using Win10.
The problem is that it uses the system’s parameters. This is OK as long as your OS and your applications have the same locale. My PC uses English language with hungarian (coincides with ISO) date format and the default paper is Letter. While LO needs A4 to print correctly on my A4 format printer.
The reason your new computer loads it fast is due to better CPU.
My (new) laptop also has Win 11, it’s aprox 4x faster than the PC and first load time si proportionally shorter. Although I see no high CPU usage on either of the computers…