Description: Plain document with a bit of color from filled backgrounds, and a TINY bit of formatting with borders. Six workbook pages, each one about two print-page size. Total file size of 5.16MB. Every time I try to open this file (and only this one, others I have work fine), LibreOffice ends up going insane. 40% CPU usage on a 2.5GHz dual-core, 250-350MB of RAM usage (again over only a 5mb file), and the whole program just locks up solid before the document finishes loading. I've tried deleting the "lock" file from every time it crashes, but it still won't open or restore properly. Initially I thought it was an issue with the install or a version bug, so I upgraded from 6.0.1 to 6.0.3, but the issue is still persisting. Someone from Reddit (when I posed this issue there) suggested I submit a bug report with the problem file. Steps to Reproduce: Happens immediately upon trying to Open affected file Actual Results: LibreOffice locks up and takes up an absurd amount of CPU and RAM until it is force-closed. Expected Results: The document should have just loaded. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36
Created attachment 141881 [details] File causing the system issues
Update - downgraded to 5.4 on a suggestion, and issue is happening on that version as well, so updated ticket notes. For some additional info, the document was originally created two days ago to record some info for benchmark testing I was running between multiple computers. Did a little bit of formatting to make it look nice, and noticed that when saving the file, it would gradually take longer and longer as I went. Eventually decided to close LibreOffice thinking it was some issue with the software itself, and after closing out the document, I was unable to open it again after that. Note that after creating the document itself, I had not closed/reopened at all until the point where the save time became unbearable. I don't know if there was some bug/issue caused by the formatting that completely broke the software, but I'm hoping someone here can figure it out.
I hope not, but your file maybe corrupt. After 40min needed to kill the application. regards
The file attached causes the hang of LibreOffice in this configuration (Windows 10 32 bits, LibreOffice 6.1.0.0): Versión: 6.1.0.0.alpha1 Id. de compilación: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab Subprocs. CPU: 2; SO: Windows 10.0; Repres. IU: predet.; Configuración regional: es-ES (es_ES); Calc: group I think too that it's a corrupted file...
Is there anything that might have specifically caused a corruption like this? I just want to try my best to avoid this sort of issue in the future. But honestly, I don't think I was doing anything outside of normal expected use.
Already freezes 3.3.0 Arch Linux 64-bit LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 Gregg: ODS files are actually ZIP files. I unzipped the file and to my horror I noticed content.xml is over 500 megabytes! It would be interesting to see, if you have a copy of the file from the era when it still opened.
I only had the single copy of the file, and as I believe I said in my initial posting, I was using it for less than 24hrs before this issue occurred.
The problem is not in LibreOffice, it is in the file. This file is not corrupted. LibreOffice 6.2.0.0.alpha0+ (current master) opens it without freezing the PC and without crashing. That take only long time and a lot of memory because there a sheet (Blackbox) with many useless data. These data are copies of the same two tables containing no data, only headers or labels of cells. The bigger of both table use 25 rows and 5 columns with some merged cells. There is copies of these tables up to the last row of the sheet, that is more than 1 000 000 rows, around 40 000 blocs of 2 tables. To repair the file: 1/ I removed all blocs but the first one. 2/ I removed the formating in the non used part of the sheet 3/ I removed the merged cells in the non used part of the sheet. It take me (my PC in fact) long time to do that, but the repaired file size is now 18,4 kB... @gregg: your problem is now to know why this sheet Blackbox has been filled with so many empty tables. Closing as NotOurBug. Feel free to reopen if you disagree. Best regards. JBF
Created attachment 142809 [details] repaired file