Thank you for trying to help me.
I have been using Writer and Calc for many years. The problem has been here for about a week.
I always open files by clicking on desktop icons or filenames in File Explorer. I am not even sure what a LO start window is or how to find it.
do you have any macros in your My Macros & Dialogs (in the left pane of the Edit Macros IDE)?
No. Tools → Macros ->Edit macros is empty expect for a Standard “module 1” empty macro. I have never worked with macros in Calc.
[Edited for clarity]
Something with menu Edit - Links to External Files…?
Does temporarily disabling your firewall make a difference?
Very strange result: I turn it off and Calc starts normally fast. I turn it back on, and Calc STILL starts normally fast. Very strange.
Maybe this is more of a Firewall problem than a Calc problem?
Disable Tools>Options>LibreOffice(Header)>Online Update.
It was set to “once per week”. Turning off did not make a difference.
Change the name of your LibreOffice user profile file to try a clean slate there if you
Did not try.
Use Alt+Tab to carefully check for any windows/dialogs that might be opening at the same time
Nothing here.
Are you using a second monitor?
Just a single monitor.
Something with menu
Edit-Links to External Files…?
I don’t have a Edit → Links to External Files…
I have a “open remote” that is blank and I have cleared recent documents list many times.
I set my computer to sleep for an hour. When returning Calc was slow in opening again. I disabled the firewall. But this time it made no difference.
Online Update is still off.
Change the name of your LibreOffice user profile file to try a clean slate there if you
Tried that just now. No difference to the problem.
If I were you, I’d clear my firewall of any file list, then go through the annoyance of having to accept or reject every program as the firewall gives you the pop-ups when you restart your computer.
Also, you could go to C:\Program Files\LibreOffice\program and look for scalc.exe. If you find it, then open up a terminal (Command prompt) and use
> cd "C:\Program Files\LibreOffice\program"
to navigate to that directory. Try starting scalc just by entering that in. I only have a Linux machine right now, but I’m hoping that it will start Calc, possibly showing errors in the command window if it is throwing any.
scale.exe startes a fresh Calc right away (as before)
Saving a blank Calc and staring that from prompt takes about 30 sec as before. There are no output on the prompt. And new prompt appearers right after pressing Enter.
If I were you, I’d clear my firewall of any file list
I tried turning the firewall off again, and this time it worked (fixed the problem). I am not too found of fiddling with the firewall. Worried that I just introduce a hoard of new problems. But I guess there may be no way around it. I just don’t understand that Calc is looking for.
Maybe the problem is in the template. Would you share this blank file?
The problem seems to have fixed it self.
Thank you very much to everybody who tried to help me.
Summery: It definitely had something to do with the firewall. I did not have the courage or know-how to start fiddling with it, so I just lived with it until now where the problem seems to have gone away.
I do have exactly the same problem. Since around two weeks calc hangs for around 30 sec if I click on an existing ods file. If I run LO from the start menu and say “File | New Spread Sheet” the empty sheet opens very fast as usual.
If I click on an existing xslx file calc opens it fast as I am used to from the past. Seems the error is file format dependant.
To make things even more strange since around 14 days another program on my computer (MagicMaps Tour Explorer, a viewer for topo maps) also hangs for about 30s before it continues operation. So the problem is not specific to LO.
When I shut down my WIFI network both problems disappear: LO opens ods files fast and Tour Explorer starts as fast as usual. If I turn WIFI on again both problems are back.
My gut feeling says the error has something to do with the updates Microsoft delivered at the March 2022 patch day. I installed them at March 11th and since then I am in trouble.
I forgot to mention that I am using Libreoffice 7.2.6.2 on Windows 11.
In case this helps anyone, I experienced this exact issue with a lengthy delay whenever opening an existing document with Calc on Arch Linux, LibreOffice version 7.3.6.2. (New documents were unaffected same as the OP.)
I didn’t actually have any printers configured since I don’t print from this machine, but based on the description of the issue and solution in this thread, I figured the delay could be a printer-related timeout. I was able to replicate this delay whenever opening the Print... or Printer Settings... dialogs from the File menu.
The issue was resolved simply by installing CUPS and starting the service. When the service is stopped, the issue resurfaces until the service is started again.
I suspect this solution should work for anyone else who is seeing the same behaviour from Calc on any other flavour of Linux when a print server/spooler is not present.
OK, I found a solution that works at least for me. I have a network printer which is connected to my WIFI and is my default printer in Windows. If the printer is turned on everything is fine. Libreoffice calc opens existing spread sheets well and also my other application (Magicmaps Tour Explorer) starts up fast. If the printer is offline opening spread sheets hangs for 30-60 seconds. The same for Tour Explorer. Obviously some applications try to connect to the default printer and if it is offline the app hangs till timeout. The solution for me was to set “Microsoft Print to PDF” as my default printer because this one is network independent and always available. If you use “Let Windows manage the default printer” you should turn off this option.
HTH,
Kuno
This is tdf#42673.
Excellent, kuno.kugel. This seems to work. Thank you.
The problem came back again after a few weeks off. (Our printer seems to have a will of it own about staying on the network.)
Now I have set CutePDF as default printer. A blank Calc saved with no content opens at normal speed now. The documents I often use seem to have a saved printer. If I change that and save, they open again at normal speed.
I can live with having some PDF-printer as default. I rarely print anything.
Strange that turning of the firewall also solves that problem.
Thank you so much, turning on my printer did it for me, but changing the default printer and the defaults did not change anything for me, as I still had to leave my printer on to load my spreadsheets quick.
I use an ethernet connection for my computer, but my printer is connected to it with wifi
.I did not have any problems until I got my new computer, which has windows 11, and deleted, and reinstalled LO about a dozen times trying to get it to work right.
I did find that saving my spreadsheet to an Excel .xls file, my Calc file would open right up.
After reading your answer, until someone fixes the Calc program, now I just leave my printer on and all is well now.
Thanks again!
Rufo70
make sure to change it in Windows, not just in libre office. you might need to turn of “windows manages default printer” option to change the default
Hello everyone,
This problem with LibreOffice taking forever to open the first document when Internet is available on the PC, no matter if it’s a Calc or Writer document or anything else, has been bugging me for at least a couple of years now. It seems to me that other people also have had similar problems. But finally I think I may have found a consistent solution.
This solution was, among other things, prompted to me by ideas about changing the default printer to something that is always present, like Microsoft’s Print to PDF. But even this solution didn’t do the trick for me all the time.
This got me looking for other possible solutions and I think I may have found a consistent workaround. At least it is working every time (for me), for every version of LibreOffice that I’ve tried. Presently I’m running version 7.5.0.1 (on my laptop) but I have also tested this on earlier versions of LibreOffice, and on other PCs, all of which are running 64-bit Windows 10.
So, here is my workaround:
In LibreOffice, go to:
I’d really love to hear if others out there can confirm that this solution actually works!
I realise this is just a workaround for the real problem, which is slowness to open the first document after starting LibreOffice with Internet connected (when there is no Internet connection this problem is non-existent). So, in my opinion, the bug itself must reside elsewhere within LibreOffice…
Also had problems with LibreOffice files opening up in a minute
My solution:
I uninstalled the printer (HP Color LaserJet) and after that libreOffice started up in 2 seconds.
Then I installed the printer again.
Now LibreOffice works as usual again. (files open in 2 seconds)