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.