Ask Your Question
1

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). [closed]

asked 2014-05-22 18:43:56 +0100

LGC gravatar image

updated 2016-03-09 21:16:26 +0100

Alex Kemp gravatar image

How can i open up the spreadsheet with this error: Read-Error. Format error discovered in the file in sub-document content.xml at 2,72157(row,col).

the calc spreadsheet is where my file is.

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-06 13:08:02.179436

Comments

For some reason, I have a gold badge, but no karma, so I can't upvote. Great question!

Ackbeet gravatar imageAckbeet ( 2014-09-27 18:46:49 +0100 )edit

5 Answers

Sort by » oldest newest most voted
3

answered 2014-05-22 23:20:03 +0100

Regina gravatar image

The file is corrupt. Make a copy and work on the copy. Change the file name extension to zip and open the container. You will see the file content.xml. Open the file in an editor and go to the place mentioned in the error message. If you are lucky you will detect the error, for example a duplicate attribute. Repair it and save the corrected content.xml to the old place. Leave the container and change the file name extension back to ods.

If you do not detect the error, you can try to open the file content.xml in another application, for example in a browser and perhaps get a more detailed error message.

If you are still without success, I fear, repairing is not possible. Do you have enabled to generate a backup? Then goto your LO user directory and look at the backup folder. Hopefully you find a version not too old.

You might be able to extract the cell contents from the file content.xml. It is not a binary file, but human readable. But that is very tedious.

edit flag offensive delete link more

Comments

Fantastic answer! Detailed, and it worked for fixing my problem, which had the same error message as LGC. Thanks much!

Ackbeet gravatar imageAckbeet ( 2014-09-27 18:47:25 +0100 )edit

Thanks for this answer.

PJK gravatar imagePJK ( 2014-10-16 18:58:34 +0100 )edit

Could someone explain that simpler and take me through step by step??

jack.lovegrove gravatar imagejack.lovegrove ( 2014-10-19 23:32:11 +0100 )edit

"Open the file in an editor" should be "Open the file in a (plain) text editor"?

Sveinn í Felli gravatar imageSveinn í Felli ( 2014-10-20 10:55:55 +0100 )edit

Perfect. Worked fine. These are the steps I used:

  • Select the .ods file, and extract the contents using 7zip
  • Edit content.xml with Notepad++
  • Move cursor to the location that the error message complains about.
  • removed the duplicate attribute, in my case, fo:font-style="italic". Save & Close file
  • create a new zip archive with the contents of the extracted files. Archive should not contain *.bak file created by notepad++, and no root folders.
  • Rename *.zip to *.ods.
  • Works!
KiranS gravatar imageKiranS ( 2015-04-03 10:34:43 +0100 )edit

This method worked, but needs one additional note: From WinXP, after renaming the file as .zip, manipulate content.xml directly from the WinExplorer: 1. Click on the .zip file name to open a directory style view of the archive contents. 2. Copy content.xml,, past into another directory, repair that copy 3. Paste the repaired copy into the ,zip file using the WinExplorer view Manipulating the .zip file by e.g 7-Zip results in a file that LibreOffice finds erroneous.

mkreich gravatar imagemkreich ( 2016-10-21 19:56:04 +0100 )edit
1

answered 2014-10-08 14:43:52 +0100

Anna Burchardt gravatar image

Hi,

I have the same problem, but in addition my problem is that I don't see the content.xml file. I zipped the file, but it doesn't look right. I would really appreciate your help and thank you in advance!

Thanks from the desperate :)

Anna

edit flag offensive delete link more

Comments

You have to unzip the file. Work on a copy and change the filename extension to zip. Then try to open/extract/unzip or whatever your packer calls it. Is that possible? Please tell us your operating system and the LibreOffce version (or other application) which was used to generate the file. When you open the file in a simple text editor, does it starts with PK?

Regina gravatar imageRegina ( 2014-10-08 15:22:20 +0100 )edit

Hi, thanks for your answer!

I have made a copy, I have zipped the file, but when I unzip it, I can see the file extension is still .ods.

My operating system is Windows 8.1 64 bit.

And I use LibreOffice Version: 4.2.6.3.

Yes, it starts with PK!

Anna

Anna Burchardt gravatar imageAnna Burchardt ( 2014-10-08 16:46:20 +0100 )edit

Hi Anna, you wrote "I have zipped the file". That step is wrong. Simple change .ods to .zip and then unzip it.

Regina gravatar imageRegina ( 2014-10-08 18:20:18 +0100 )edit

Thanks.. I had problems with that, but now I know, where to look. I have, though, solved the problem. I opened the file through Google docs - I was lucky it worked - and then I have saved it as .ods.

I know I am not a technical genius, but thanks for your help and time. Two months of work is saved and a backup created :)

Have a nice day,

Anna

Anna Burchardt gravatar imageAnna Burchardt ( 2014-10-09 09:55:54 +0100 )edit

Hi, applying these steps don't work for me. Is there a person who can fix this error for me?

hun gravatar imagehun ( 2019-02-12 05:07:54 +0100 )edit
1

answered 2015-09-28 00:22:26 +0100

tdoc gravatar image

I have the same problem. It reads: Read-Error. Format error discovered in the file in sub-document content.xml at 2,114358(row,col).

When I try to open content.xml in browser, it said: XML Parsing Error: mismatched tag. Expected: </text:p>. Location: file:///home/forevernikn/Translate_Proposal_Making%20All%20Voice%20Count_ALPENSULTRA/content.xml Line Number 2, Column 114359:<office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:nam&lt;/p&gt; &lt;p&gt;So, I can't check the duplication or any error. &lt;/p&gt; &lt;p&gt;I tried to open it using Google drive couple times, always failed to upload, something error. I managed to upload it but it won't open.&lt;/p&gt; &lt;p&gt;I have tried all answers and steps mention here but still it won't open. Anything else I can try? I am still using traditional way to translate document until it solved.&lt;/p&gt; &lt;p&gt;Thank you Niken&lt;/p&gt; ">

edit flag offensive delete link more

Comments

If the instructions here are not enough to let you repair the file yourself, then you need to provide the file for download. Perhaps someone else has time to try to repair it.

Regina gravatar imageRegina ( 2015-09-28 23:43:27 +0100 )edit
1

answered 2014-11-19 05:41:44 +0100

Lucky Raghavan gravatar image

Hi I got my liberOfficeCal.ods file currept while i try to open. it throw error message "Read-Error.Format error discovered in the file in sub-document content.xml at 2,94039(row,col)." I tried to open this file in different Liberoffice version.. i saw their is already Bug raised in Liber Office...So i understoood that their is problem with Liberoffice Cal...

Recover File... I spend almost 2 hour google to find any alternate software who can recover my file or open online... ohhhhh...Finaly i tried Google Doc Create Documents--> Go to file-->New-->SpreedSheet.. it will open new spred sheet now here again go to File-->Open-->Upload the file.. It will open ( I hope it works..for you) Now you can save the file as you wish to save in different fomat.....

edit flag offensive delete link more
1

answered 2014-10-06 18:40:28 +0100

LibreAddict gravatar image

To add to @Regina 's great answer, the error I found in the content.xml file wasn't in the mentioned cell number. It was enough to extract the content.xml file and open it in a browser to see that some styling attribute at the beginning of the document was for some reason duplicated. Removing the duplication and putting back the content.xml file in the ods file using a zip utility fixed the problem. It is worth mentioning that updating the content.xml to the ods file wasn't successful in Mac OS X. The archiving tool did not produce a valid ods file after zipping the directory content. I had to switch to Linux and took a couple of minutes to solve the problem. Maybe a tool on windows works fine as well.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-05-22 18:43:56 +0100

Seen: 14,914 times

Last updated: Nov 19 '14