Description: On rare occasions but it's happened around 8 times so far since I've been on LibreOffice, a spreadsheet I use everyday cannot be opened. I have screenshots of the error message. It says "Read Error. "Format error discovered in the file in sub-document content.xml at 2,4181533(row,col). This is very distressing because I lose so much work. I think it is a fatal bug in LibreOffice. This is the first time I'm reporting it. This is not a minor or normal severity as below. It is serious. Steps to Reproduce: 1. Close spreadsheet as normal and shut down computer at night. 2. Next morning I get the Read Error. 3. Cannot get into the speadsheet, it's impossible. I have to use a past saved one but I lose weeks of work. Actual Results: It cannot be reproduced because it is a bug that occurs sporadically and not often. But it has happened at least 8 times since I started using LibreOffice which has been for about 5 years. Expected Results: I couldn't get into the spreadsheet. Only the spreadsheet I was working on. all the other spreadsheets can be opened and read as normal. Reproducible: Sometimes User Profile Reset: No Additional Info: Something is seriously wrong and I don't know what it is. It happened with a previous version of LibreOffice and it is happening with this one too which is a later version and quite recently installed. I didn't think it would happen on this later version. This is the first time it has done so, but it happened several times on the previous version. I don't think the version is the problem.
Created attachment 200635 [details] Screen Shots of the error, and a screen shot of the Windows version The attachment is a LibreOffice Writer file which shows 3 screenshots, 1 with the LibreOffice Version, 1 with the read error, and 1 with the Windows version images.
Could you provide us the document for us to reproduce ? Remove all sensitive data from the data Thanks
DW: An ods file is in fact a zip file with a specific structure. Here is what you can do: 1) make a copy of your file 2) rename your file to have the zip extension instead of ods 3) unzip your file 4) you can investigate in content.xml Also, what LO version do you use? 6.1 is an old one, last one are 24.8.6 or brand new 25.2.2 Mateusz: I don't think the reporter can sanitize his file since he can't even open it. DW: you can attach your file to the bugtracker but you must know that it means it'll be publicly available.
Right, DW you can try using another software to sanitize the file, such as onlyoffice
Created attachment 201318 [details] Good file
Created attachment 201319 [details] Corrupt file
I have had a similar problem going back many years, except with Writer. Once in a while I will open a file in writer and discover that it has been overwritten with a couple megabytes of gibberish. The files are accessed from a USB drive on Windows and MacOS. It happens with doc and odt files, with or without images, with or without links. It happened again recently and I ran across this report. I'm including 2 files, one is corrupted, the other is the previously not corrupted version.
Dear DW, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear DW, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp