Ask Your Question
0

Can`t open spreadsheet (Read-Error) [closed]

asked 2014-09-25 14:31:18 +0200

baniza gravatar image

updated 2014-09-25 20:52:55 +0200

ratrace gravatar image

Hey,

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 ?

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 20:35:42.837695

Comments

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

ROSt52 gravatar imageROSt52 ( 2014-09-25 15:02:19 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2014-10-08 14:59:48 +0200

Anna Burchardt gravatar image

http://ask.libreoffice.org/en/questio... - it seams this answer works for some, but unfortunately not for me. I cannot find the content.xml document.

edit flag offensive delete link more
0

answered 2014-10-11 11:27:52 +0200

Jens S gravatar image

@Anna 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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-09-25 14:31:18 +0200

Seen: 804 times

Last updated: Oct 11 '14