Can`t open spreadsheet (Read-Error)


When I try to open one of my spreadsheets, the message “Read-Error.
Format error discovered in the file in sub-document content.xml at 2,8549(row,col)
” shows up and it doesn`t open.

I tried opening it with Excel, but it didnt work aswell. Unfortunately I didn`t make a backup.

Can anybody help me with that problem ?


Which OS? Which spreadsheet fileformat? Please provide more details.

I can not open my spreadsheet it comes up with this error: Read-Error. Format error discovered in the file in sub-document content.xml at 2,72157(row,col) - #11 by AnnaBurchardt - it seams this answer works for some, but unfortunately not for me. I cannot find the content.xml document.

You need to download 2 tools to manipulate the file with the error. Search for ‘7-zip’ and ‘Notepad++’ in Google and install them on your Windows computer.
Right click now on the error file and select 7-zip → Open. This window shows the content of the file - some folders and some files. One of the files is content.xml - right click on that and select Edit. Normally Windows notepad will open - but I prefer Notepad++, so go the options menu in 7-Zip and change this. Notepad++ use colour syntax and cursor-position.
Place the cursor on the error position in Notepad++ and syntax-coloring will colour the start-tag and end-tag light blue. If it is about some formatting so just delete the whole tag around the error. Save the file and close Notepad++ , accept 7-zip updating the content.xml in the error file. Finally just close 7-zip and you should now be able to open the file with Calc.