Description: I came from LibreOffice 7.1.8.1 and updated to 7.3.6.2 (later to 7.4.2.3) with Windows 10 22H2 19045.2130 each. Soon i figured out loading of calc-files like ods took a long time. Sometime up to one minute. I could reproduce that error on one more machine. Going back to 7.1.8.1 doesn't solve the problem, but makes it worse. The files don't open anymore, LibreOffice just crashes. It doesn't matter if I open the files directly on that certain machine or via a smb share. Steps to Reproduce: 1. Install 7.3.6.2 over 7.1.8.1. 2. Try to open a saved calc-file. Actual Results: It happened, what i already described in the above description of the bug. Expected Results: File should open in a shorter time than 1 min. or they should open at all. Reproducible: Always User Profile Reset: Yes Additional Info: File should open in a shorter time than 1 min. or they should open at all.
Created attachment 183277 [details] Empty calc file created with LibeOffice 7.1.8.1
Created attachment 183278 [details] Empty calc file created with LibeOffice 7.4.2.3
Both open without any delay for me: Version: 7.3.7.1 (x64) / LibreOffice Community Build ID: ee816339cde623389f19e5eb99a60dbf03ee8b66 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 17dfc9a9da009cc23d2222e3fb4e2cef9c97d581 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo Please test with a clean profile, Menu/Help/Restart in Safe Mode
Same as before. I had to click "Tested it with a clean profile" prior to be able to create a new bug report. I even deleted "%UserProfile%\AppData\Roaming\LibreOffice" which should deliver the same effect. On the machine with 7.3.6.2 I unstalled it an installed 7.1.8.1 again. LibreOffice doesn't start there anymore but in safe mode only. I would not have opened a bug report, if this wouldn't happen on 2 PC at the same time. I got more W10 machines here, I could test. But I'm afraid to make them inproductive this way. Btw it's not even loading a table, but also changing Text in writer. If I want to change the Kerning between the letters it takes almost 1 min. to load that menu, too. I also believe, it could be a matter of Windows 10, since my W11 Laptop and 2 Desktops of my sons with W11 are not affected.
You can report, when you see the issue, it's fine so. But without a way to reproduce the issue, it's no easy for a dev to do something. Maybe something in relation with your machine, some driver, some hardware.
No repro in Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 8dcf53b3d2c0e30317c1e247f01d07ab448ec1ae CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded Alex, do you have HDD or SSD in these machines? Do you have any antiviruses there?
Hello Roman, I kind of gave up, since I was told noone could reproduce this error but me. Unfortunately I got the same issue on 3 machines in a row. And I hesitate to update other machines to a newer LO version. All machines have 128 GB SSD but different types/manufactorers, two 8 GB and one 16 GB RAM. There is no particular antivirus software on it but MS defender. All with currend MS W10. If it's necessary I could provide you the chipsets and CPU maybe on Friday. To be honest it really sound like #109530. I also figured out, I can't start 7.1.8.1 on one machine any more. Even after a fresh install. I figured out, it happens alsways in a same pattern, too. If I start Calc the first time and load a file - no matter if LO is started first and the file loaded in it or LO is startet with the file via double click - it take the minute. But if I don't close it anymore, every loading after that goes fast like before. I also noticed long loading times for dialogs like changing font. To load the first dialog takes sometimes more than a minute. But if I do it again, the dialog appears under a second. I'm not sure, if/how this could help. I even thought about making a video to show these effects and to prove I'm not making it up.
Have you tested opening the file while you are in safe mode. Menu/Help/Restart in Safe Mode
No safe mode doesn't work for me. And it's even getting worse since this morning: Last night I made the upgrade to 22H2 on another machine with Windows 11 (this time not W10). Since then I got the same problem here and I didn't even touch LibreOffice 7.3.6.2. But instead of a pause of appr. 1 min. LibreOffice crashes completely. Files aren't loaded - not even in safe mode. Just for me: In my understanding the open file format is just zipped content and some xml stuff. Does saving/loading use a Windows-API to do that? I'm asking this, because opening plain text-files works fine even in standard mode. And maybe that's the reason why 22H2 was offered on my sons Laptop last night and isn't since this morning. Which supports my conspiracy theory. But this way I can't try to reproduce the problem there. Is there a possibility to get some decent log-file, which I could provide? I know that from bug reports in Linux.
I have win10 with 22H2, and no issue here, with none of the LO versions that I have. You can test with a portable version. https://downloadarchive.documentfoundation.org/libreoffice/old/7.4.2.3/portable/
Please take a look if it could be a similar case than here https://bugs.documentfoundation.org/show_bug.cgi?id=151680#c16
Indeed it's kind of similar. But in the end it seems different: in this Bugreport the files somehow opens in the end. In addition to these effects they don't open here. And since I installed 22H2 on my private W11 machine, I only can start LO without files. But if I try it with a double click, inside LO via the recently used symbols or even the menu (file -> open -> etc). it crashes. It even crashes in save mode, no matter if I start it via the menu (help -> save mode) or the link inside the start menu.
[Automated Action] NeedInfo-To-Unconfirmed
I'm getting closer to the cause: After uninstalling 22H2 on my W11 Laptop the error/bug is gone: LibreOffice starts within seconds even with a file! Unfortunately I can't uninstall it on my W10 machines, since MS deletes the backup after 1 oder 2 weeks. Maybe that's the reason why 22H2 wasn't offered since the day I opened this bug report on 2 other W11 machines. Even on my laptop I don't see it offered anymore. I don't think MS did it because of me. I'm not important enough. But I guess they found certain problems with 22H2 by themselfes. I'll try the 2022-11 Kumulatives Update für .NET Framework 3.5, 4.8 und 4.8.1 für Windows 11 für x64 ((KB5020695)) first. I'm excited if it happens again if 22H2 is offered once more.
I suggest to close this report as Not Our Bug
I finally could surely reproduce the issue on my W11 Laptop: I installed/uninstalled 22H2 several times. And every time it was installed, LO had the problem. Without 22H2 there's no problem. And I also figured out LO never crashes. It just needs it times to load a file. Sometimes this needs 2 hours and more, which is pretty bad and makes LO unuseable anyway. So first of all I don't know how to mark it this way. Second I don't know your definition of "Not Our Bug". LO seems not to be the cause/reason for this problem in the first hand. But since I figured out 22H2 is the reason on my computer it might be the problem on others OS, too. So to me it seems a little presumptuous to end this just as nob. But anyways: Feel free to handle it this way.
Alex, do you still experience this with both Windows and LO up to date?
Verify you don't have a network driver defined and not connected. Or a printer not connected with the option Menu/Tools/Options/Load&Save - General – Load printer settings with the document enabled.
*** Bug 157831 has been marked as a duplicate of this bug. ***
I have discovered and corrected my problem with a long time to open a file. I had turned off a printer while waiting on a replacement ink cartridge. When I turned the printer back on the problem was gone. Next time I turn off a printer, I will uninstall it.
Sorry @Steve, fixed is when a patch has solved the issue. Not the case here.
Ah, we can mark as a duplicate of ancient bug 42673 then. Thank you for testing further and reporting back! *** This bug has been marked as a duplicate of bug 42673 ***