Ask Your Question

"You will see the file content.xml. Open the file in an editor and go to the place mentioned in the error message." Can someone explain this? [closed]

asked 2014-10-20 01:56:40 +0200

jack.lovegrove gravatar image

updated 2014-10-20 13:29:08 +0200

I have a similar problem to the person that asked this question:

I manage to get so far into the answer but get stuck when it mentions opening the file in an editor? What is an editor and how will I find the place where the error message is?


Here is the document: C:\fakepath\BHAFCcopy.ods

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-05 09:11:02.232949


I want to assure you, I don't simply try to get rid of this. It just seems you will have far to go to understand the necessary topics and to apply the new knowledge flexibly enough to solve your problem. If it is really as urgent as it seems you should try to find someone doing it for you. If the contents of your file aren't confidential you may even attach it to your question. I will vote up your question. Consequently you will have enough karma points for attaching files.

Lupp gravatar imageLupp ( 2014-10-20 13:18:42 +0200 )edit

I have attached the document.

jack.lovegrove gravatar imagejack.lovegrove ( 2014-10-20 13:30:53 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-10-20 10:49:34 +0200

Sveinn í Felli gravatar image

updated 2014-10-20 10:51:33 +0200

An editor in this case is a plain text editor, as opposed to LibreOffice Writer / MS Word which is a document editor. Examples would be Notepad, Notepad++, gEdit and Emacs. Googling "xml editor" would have added to that some editors with features like xml-highlightning (coloring the xml syntax, leaving the data intact).

Now, if you're on Windows, please don't use Notepad; it has a history of inserting wrong type of line endings (carriage returns). Notepad++ is a frequent choice on Windows.

To find the error you'd refer to the error message:

Read-Error. Format error discovered in the file in sub-document content.xml at 2,34352(row,col). What to do?? Someone explain simply? STILL NEEDS ANSWERING. URGENT!

This indicates row number 2 and column number 34352. Use the search feature from menu or Ctrl+F (most applications) to locate the placement in the file. Study the surrounding XML-entities (entries); are they different from the rest?

But if you read the linked question above, you see that the real reason in that case was a duplicate attribute at the beginning of the file. Check for such anomalies by opening content.xml in a browser (Firefox, Cromium, Opera etc), these will complain and highlight the error. Find that in your text editor, correct, save file and proceed to reintegrating content.xml into the .zip file you just created. Then rename it to .ods and test in LO.

Hope this helps.

edit flag offensive delete link more


Great, I downloaded Notepad++, refering back to the original question, how do I open just the content.xml file in Notepad++?

jack.lovegrove gravatar imagejack.lovegrove ( 2014-10-20 12:49:44 +0200 )edit

@jack.lovegrove: either extract the file from the ODS, or open the ODS using 7-Zip and then edit the content.xml, assuming Notepad++ is default for XML files.

rautamiekka gravatar imagerautamiekka ( 2014-10-20 15:16:03 +0200 )edit

answered 2014-10-20 14:52:09 +0200

Lupp gravatar image

updated 2014-10-20 14:53:20 +0200

(This is not actually an answer. It's an anchor for an attachment mainly.)

In the content.xml I found dozens of problematic (illegal?) redefinitions of font properties in the extremely fragmented styles collection. On deletion of such definitions surely some legal definitions will also have vanished. I'm confident that will not cause too much trouble and need of defining format properties anew. An advice: Use less!

In the attachment you find the reintegrated ods which resulted from my work. Good luck! RepairedSuperficiallyNowarrantyOfAnyKind.ods


edit flag offensive delete link more


So there should be content and auto-resizing columns and rows ? LO on 7 Ultimate x64, I see no content besides small columns and rows. Notepad++ shows no highlighting errors and running through for clarity didn't help.

rautamiekka gravatar imagerautamiekka ( 2014-10-20 15:01:40 +0200 )edit

Lupp, thank you so much. If I ever meet you, please let me buy you a drink!

jack.lovegrove gravatar imagejack.lovegrove ( 2014-10-20 15:12:43 +0200 )edit


1) The ods was stored with the third (empty) sheet active.

2) I also used Notepad++ (v6.6.9 portable). Having installed the plug-in "XML-Tools" (V2.3.2 β4) I got the necessary hints. The XML-Tools come with different PrettyPrint facilities.

Lupp gravatar imageLupp ( 2014-10-20 15:37:06 +0200 )edit
Lupp gravatar imageLupp ( 2014-10-20 15:43:39 +0200 )edit

@Lupp: Ohh, that's why. My bad for not checking it.

rautamiekka gravatar imagerautamiekka ( 2014-10-20 15:44:46 +0200 )edit

Question Tools

1 follower


Asked: 2014-10-20 01:56:40 +0200

Seen: 2,925 times

Last updated: Oct 20 '14