Open Office Read-error Format Error Discovered in the File in Sub-document Content.xml

I have an fault in an OpenDocument calc spreadsheet that prevents me from opening it:

"Format error discovered in the file in sub-document content.xml at 2,141422(row,col)."

I have tried unzipping to remove the style section of tags in the content.xml file, and re-zipping back to a .ods file to no avail.

Delight can anybody help? I have attached the spreadsheet.

by **JohnSUN-Pensioner** » Fri January xiv, 2011 1:27 pm

Something like that? At that place actually was a mistake: instead of "type" was "tupe"...

by **nph2011** » Fri Jan 14, 2011 ane:41 pm

That's wonderful! Thankyou ever so much JohnSUN-Pensioner. :bravo:

You accept saved me an awful lot of work in updating a much older file that I had saved as a backup. Later unzipping the faulty spreadsheet and using Microsoft Wordpad as a text editor, I had no easy way of counting 141422 characters along the 2d line in lodge to check it.

May I ask, did you use some type of XML parser, or did you have a text editor with line and character numbering available?

by **Hagar Delest** » Fri Jan 14, 2011 one:43 pm

Re: Format mistake discovered in the file in sub-document

by Hagar Delest » Fri Jan 14, 2011 one:43 pm

LibreOffice 7.2.1 on Xubuntu 21.04 and seven.2.i portable on Windows 10

past **nph2011** » Fri Jan 14, 2011 1:50 pm

Thanks for replying Hagar de l'Est. I did really read that thread and I had tried that method before posting on the forum. Unfortunately a similar error occurred when I rebuilt the .ods file by re-zipping the edited content.xml file together with the other previously extracted files. I'm now on the search for a simple text aditor with line/character numbering, then if it happens in time to come I can fix it myself.

by **JohnSUN-Pensioner** » Fri January 14, 2011 1:53 pm

nph2011 wrote:...did you have a text editor with line and graphic symbol numbering available?

Exactly This time I took EditPad Pro

by **nph2011** » Fri Jan xiv, 2011 2:02 pm

Now that I call up nearly this, I accept a linux operating system on CD-ROM that is bootable lying effectually the house somewhere. I suppose I can use the native "six" editor and determine the graphic symbol location with <number><pipe> using that in future.

Thanks once again for your help, you've fabricated what looked like it was going to be a miserable twenty-four hour period, very vivid (even though it'due south cold and rainly).

by **Hagar Delest** » Fri January 14, 2011 2:54 pm

XMLCopy Editor is quite good under GNU/Linux IIRC.

by **fst** » Fri January 14, 2011 ix:32 pm

Hi,

for hereafter use just untag 'Size Optimization for ODF Format'.
This will brand the xml files in the container pretty printed and non but a single long line.
The size will not increment so much and the advantage of a readable IMHO is amend than the deviation of a few bytes.

The setting can be establish under Tools-Options-Load/Save-Full general

Frank

by **aspsak** » Thu Sep 18, 2014 3:19 pm

I take faced the same problem and I solved below ways.
Stride 1: open file_name.ods file in notepad++ and then salve as file_name.zero
Step two: open up the file_name.nothing using winrar (not excerpt) , from this I can seeing the content.xml file.
Pace 3: open the content.xml (by default xml file using in notepad++ app) in notepad++ and copy the whole data.
Step 4: Validate that xml content and rectify the errors. Then save it.
Stride five: now open up the file_name.cipher using notepad++ and salve it as file_name.ods

At present it solved!

by **bluebilly** » Thu Aug 06, 2015 1:43 pm

I have the same problem. Please assistance. Tks

by **bluebilly** » Thu Aug 06, 2015 3:17 pm

I tried a little, but i resolve the trouble with the aspsak solution.

by **stianx** » Fri Oct 09, 2015 x:02 pm

I have an odt document, when I open up it in author information technology says: Format fault discovered in the file in sub-certificate etc. I tried apsaks solution above simply when I tried to open the content.xml file it was blank. I really desire this file dorsum. Anyone who can walk me through an alternative recovery solution?

by **RoryOF** » Fri Oct 09, 2015 ten:12 pm

If at that place is cypher in the content.xml file (and its size is 0) so forget the certificate file. You might have a fill-in or a temporary file in the OpenOffice backup or temporary directories. I'd run an undelete utility such as Photorec or Recuva to see can that observe a deleted old copy.

by **stianx** » Friday Oct 09, 2015 xi:21 pm

Cheers. Turns out there was content. I don't know why it showed up blank at first. I ran a validation using this:

http://world wide web.xmlvalidation.com/

and it detected a couple of errors. Even so, I have no thought where to get from there, how to fix the errors. Not too familiar with code ...

2: 1708 cvc-elt.1: Cannot find the declaration of element 'office:document-content'.
2: 4527 Attribute "name" bound to namespace "urn:oasis:names:tc:opendocument:xmlns:function:1.0" was already specified for element "style:mode".

by **RoryOF** » Fri Oct 09, 2015 xi:28 pm

I have not sufficient knowledge of XML to advise - or indeed, to right - those errors. I normally use XML copy editor. All I can suggest is that you try different XML editors until yous find i that highlights the error(s) in some articulate way, delete the erroneous text then reinsert the repaired file into the OO archive.

past **stianx** » Mon Oct 12, 2015 10:42 am

Cheers for your tip RoryOF. It seems pretty straightforward. However, I did not succeed in manually fixing my XML, my validator just kept finding new errors, probably as a result of my clumsy handling of the editing process, dunno. Eventually I found a link to this handy piddling piece of online software in another forum which did the job for me:

https://online.officerecovery.com/author/

It'south free if you share. Took xxx seconds, and now I can read my file over again.

by **huymoto** » Tue Dec 17, 2019 9:37 am

I have an error in an OpenDocument calc spreadsheet that prevents me from opening it:

"Format mistake discovered in the file in sub-document content.xml at 2,172788(row,col)."

pls help me !

by **John_Ha** » Tue Dec 17, 2019 4:25 pm

Try this file.

There were about 20 occurrences where tabular array:content-validation-name="xxxx" was repeated. The repeated values were different (every bit beneath, val3 and val2) and I do not know whether I should have deleted the first occurrence or the second. I guessed and I deleted the second occurrence each time so, while the file at present opens, information technology may exist corrupted. Check it carefully!!

Run across [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and afterward) to recover previous versions of the file (is there something like on MacOS and Linux?);

b) recover your file as information technology was when you last opened or saved it, or as it was when information technology was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted;

d) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. This will recover your file as it was when yous concluding opened or you last saved it.

See [Tutorial] Format mistake discovered in sub-certificate for the method.

Edit: I also created another repaired file where I deleted the first occurrences.

I volition be very interested to know if one file is better than the other or if you cannot meet any differences betwixt the two files.

by **Gangadhar** » Sat Nov 28, 2020 12:58 pm

I tin can non open my spreadsheet it comes up with this error: Read-Error. Format error discovered in the file in sub-certificate .
Kindly help me to recover of reopen my file. The file is attached herewith.

past **robleyd** » Sat Nov 28, 2020 i:42 pm

Re: [Solved] Format error discovered in the file in sub-docu

past robleyd » Sat Nov 28, 2020 i:42 pm

Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.ii - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for half-dozen.4.half-dozen past Eric Hameleers) - Slackware 14.2 - 64 flake
Apache OpenOffice 4.1.four - Windows 7 Virtual machine

by **Gangadhar** » Sat November 28, 2020 6:38 pm

Thank you very much

Open Office Read-error Format Error Discovered in the File in Sub-document Content.xml

[Solved] Format error discovered in the file in sub-document

[Solved] Format error discovered in the file in sub-certificate

Re: Format error discovered in the file in sub-certificate

Re: Format error discovered in the file in sub-document

Re: Format mistake discovered in the file in sub-document

Re: [Solved] Format error discovered in the file in sub-docu

Re: Format mistake discovered in the file in sub-certificate

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format mistake discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format mistake discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format fault discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Read-Error. Format mistake discovered in the file in sub-docum

Re: [Solved] Format error discovered in the file in sub-docu

Re: [Solved] Format error discovered in the file in sub-docu

Who is online

0 Response to "Open Office Read-error Format Error Discovered in the File in Sub-document Content.xml"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel