Description: Whether opening an .ods file by double clicking on it or by opening Calc and using File -> Open or File -> Recent Documents, Calc seems to pause for a period of time that is suspiciously close to 60 seconds before attempting to open the file. The total time taken is about 61 to 62 seconds. During this pause, the "Loading Document" status is shown at the bottom status area, and the accompanying progress bar does not fill. The Task Manager does not show any significant CPU activity. After the 60 seconds have passed, the file opens and Calc works fine. Even the simplest spreadsheet files show this behavior. The same files saved as .xlsx open without any pause. If my PC is disconnected from my wi-fi, the pause doesn't happen, .ods files open normally. Almost as if the 60 second pause is some sort of networking timeout. I've observed this behavior with two or three different v6.x.x.x releases. It was an issue for a period of weeks last year, but it went away without any specific action on my part. It has lately become a problem again. Steps to Reproduce: While connected to internet: 1. Open LibreOffice Calc 2. File -> Save As "slowfile.ods" 3. Close document 4. File -> Recent Documents -> "slowfile.ods" Actual Results: Calc re-opened "slowfile.ods" but took 60 seconds to do so. Expected Results: Calc should have re-opened "slowfile.ods" in a second or two. Reproducible: Always User Profile Reset: No Additional Info: Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: CL
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 171461 [details] This file triggers the behavior indicated.
5 sec in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 15a9bee9ef26ce13ed1e26319306a88b6d886158 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded
Also a few seconds for me with Version: 7.1.3.1 (x64) / LibreOffice Community Build ID: fa76d07d7006a0e2866c3247cef2d5eb55ae8369 CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Please test with a clean profile, Menu/Help/Restart in Safe Mode
I've tried resetting the profile, it made no difference.
Point is most likely "If my PC is disconnected from my wi-fi, the pause doesn't happen". So test file may not be relevant. This is duplicate of Bug 133621 which I marked as duplicate of (opposite) bug 131128. So this can be a duplicate of that one or bug 92826. In addition to profile reset, solution also can be: Tools > Options > Internet > Proxy > Proxy server = None Note: if you don't need it, turn off Options-Language Settings -Languages Asian and Complex.
Thank you all for your attention and suggestions. Setting "Proxy Server" to "None" hasn't changed anything. Very curious what network traffic would be triggered by opening a local .ods file, but not by opening the .xlsx version. Although I do have a cloud sync service (MS OneDrive) active, the .ods files in question here aren't in a synced directory. To be absolutely sure, I tried 1) Moving some .ods files to a different volume with no synced directories and 2) Completely shutting down OneDrive before loading an .ods file. Neither made any difference. I tried doing a WireShark capture while LibreOffice started up slowly, but I don't know what to look for in the result.
[Automated Action] NeedInfo-To-Unconfirmed
Today the delay opening Calc documents is gone. There is a thread on Reddit: https://old.reddit.com/r/libreoffice/comments/mytk3l/calc_files_take_long_times_to_load_writer_files/ I'm not the only one to experience the delay, but it went away for everyone at the same time. It sounds very much like LO tries to connect to some internet service that has been misbehaving until recently.
OK, let's close it as WFM. You can reopen this bug report if you'll see that delay again