Description: A large spreadsheet file that can be saved in version 7.4.3.2 (x86-64 Build 1048a8393ae…) cannot be saved after version 7.4.3.2 is upgraded to version 7.5.5.2 (x86-64 Build ca8fe7424263…). The green bar at the bottom of the screen proceeds very quickly to the halfway point and then freezes. Eventually a box appears that indicates “Libra Office has stopped working” with “A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.” It does not matter if there have been changes to the spreadsheet or not. Once a large spreadsheet file (.ods) is opened, it cannot be saved. If changes have been made, recovery only brings back the original file with the original file name. All changes are lost. There are two new files left after the save attempt. An .ods# of less than 100 bytes and a .tmp file of 0 bytes. Smaller spreadsheets seem to save fine. The extent of the spreadsheet that cannot be saved is A1:AD393213 and it has a total file size is 68,183,534 bytes. The OS is Windows 11 Pro (Version 10.0.22621 Build 22621 – no patches or updates have been applied). A second try by doing a complete restore of C:\ from a backup image to bring back version 7.4.3.2 followed by an upgrade to version 7.5.5.2 produced the same before and after results. The upgrade in both cases used the defaults and went smoothly. It may or may not be because of the size, but that is the most noticeable difference. Steps to Reproduce: 1.Apply "Save" or "Save As" to an open large spreadsheet file. 2. 3. Actual Results: Save does not complete and results in a error message. "Libra Office has stopped working” “A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.” Expected Results: File saved Reproducible: Always User Profile Reset: Yes Additional Info: Only noticed on one file, but it is the only file available that large. However, earlier revisions of the same file produced the same result. Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 4; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Please test in safe mode, Menu/Help/Restart in Safe Mode
I did. I must have missed checking the box the last time I filled out the form. My apologies. The results were the same.
Then can you share the file that can be saved with 7.4.3.2, but not now?
I did not want to make the file that prompted the bug filing public, so I tried creating a nonsensical file to duplicate the problem and was successful. The way I did it was to create the first line of data the same width (A1:AD1) as my original file and then filling down until the problem occurred using version 7.5.5.2. A summary follows. 336,960 lines (or less) - file was able to be saved 336,970 lines - file was not saved but calc did not exit. Error message said “Error saving the document myfilename: General Error. General input/output error.” 336,975 lines (or more) – file not saved and calc exited. Error message said “Libreoffice has stopped working A problem has caused the problem to stop working correctly. Windows will close the program and notify you if a solution is available. The largest file size saved successfully (336,960 lines) was 67,453,522 bytes. The largest file size saved was then opened in version 7.4.3.2 and increased to 340,000 lines using fill down. It was then saved with a file size 68,062,937 bytes. This 340,000 line file was then opened successfully in version 7.5.5.2, but when a save was attempted, with no changes made to the file, the error “Libreoffice has stopped…” appeared and Calc then exited. This last step was also repeated in safe mode. If the 340,000 line file had lines 336,961 through 340,000 deleted after it was opened in 7.5.5.2, it then could then be saved. The original file that prompted the filing, which had different data, functions, and also macros, exhibited similar behavior but the number of lines and file size where the problem developed were of different (less) values. How would you like me to share the nonsensical file?
[Automated Action] NeedInfo-To-Unconfirmed
Created attachment 188949 [details] File saved with 7.5.6 Works for me with: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 218a7650a5cf03f895bed19c68d6f02daec536e9 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 and Version: 7.5.6.0.0+ (X86_64) / LibreOffice Community Build ID: f3b62a9fb3ae38a152fe95dac53903bd1751595c 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
Base on what m.a.roisv found, I downloaded LibreOfficeDev_7.6.1.0.0_Win_x86-64.msi (7.6) from the dev area and installed it. When I tried it, using my Quick Launch shortcut, the problem “seemed” to be still there. When I checked “About” however, it said I was still running 7.5.5.2 (7.5). On further investigation I found that 7.6 had been installed separately from 7.5 and not as an upgrade. As a result I next used the newly installed desktop icon to launch Calc 7.6 and when I loaded my large file I was then able to save it. At that point 7.4 and 7.6, based on my results, both had no problems with a large file, but 7.5 did. My next thought was the long shot that the problem with 7.5 might be something that developed as part of the upgrade process that 7.6 did not use. As a result I went back to my square one image, uninstalled 7.4 and removed all references that I could find including the short cut I had created and the leftover files in the Users Apps area. I then used CCleaner to remove any references it could find of Libreoffice in the registry. I next installed 7.5 and tried saving the large file again. The problem remained so it does not seem it has something to do with the upgrade process. The bottom line is that it appears the problem is in someway connected to 7.5 alone, at least on my PC. The good news is that it also appears I can either switch to the dev version of 7.6 now, or stay with 7.4 until the production version of 7.6 is released. Either way, I now consider this a non problem for me. __________ The about 7.6 data that worked. Version: 7.6.1.0.0+ (X86_64) / LibreOffice Community Build ID: 6980f69c559861aba7279d5b90ae09f0347fa4d4 CPU threads: 4; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
You can download 7.6.0.3 from https://downloadarchive.documentfoundation.org/libreoffice/old/?C=M;O=D