[Solved] Error discovered in sub-document content.xml

Discuss the word processor
Chels
Posts: 2
Joined: Fri May 25, 2018 10:23 pm

[Solved] Error discovered in sub-document content.xml

Post by Chels »

Please help!

I try to open this document, but get "Read-Error. Format error discovered in the file in sub-document content.xml at 2,3228 (row,col)."
I'm not tech-savvy in the least and find previous posts about how to fix this problem terribly confusing (though I've tried to follow to step as best as I can... to no avail).
If anyone can recover this file, many many thanks in advance!!
Last edited by Hagar Delest on Sat May 26, 2018 12:39 pm, edited 2 times in total.
Reason: tagged [Solved].
OpenOffice 4.1.5
Windows 10
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Post by robleyd »

Please try the attached file.

I'd suggest that you consider installing the Timestamped backup extension so you can keep multiple backups of you documents against the possibility of a similar incident happening..
Last edited by robleyd on Sat May 26, 2018 2:39 am, edited 1 time in total.
Reason: Remove attached file
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Chels
Posts: 2
Joined: Fri May 25, 2018 10:23 pm

Re: [Hint] How did I fix my ODT file

Post by Chels »

robleyd wrote:Please try the attached file.

I'd suggest that you consider installing the Timestamped backup extension so you can keep multiple backups of you documents against the possibility of a similar incident happening..
Greatly appreciated!! Your quick help has saved me days of work. :D Thank you, thank you. And absolutely taking your recommendation in order to prevent this *diverted* disaster from happening again.

All the best
OpenOffice 4.1.5
Windows 10
destros
Posts: 1
Joined: Fri Jun 08, 2018 4:09 pm

Re: [Hint] How did I fix my ODT file

Post by destros »

robleyd wrote:Please try the attached file.

I'd suggest that you consider installing the Timestamped backup extension so you can keep multiple backups of you documents against the possibility of a similar incident happening..

I'm having a similar problem and am hoping I won't have to create the document all over again since it won't open now. I see where you indicate an attached file but I don't see one anywhere in the post.
oPEN oFFICE 4.1.5
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Error discovered in sub-document content.xml

Post by robleyd »

The attached file - the repaired version of Chels' file - was removed at Chels' request.

[Tutorial] Format error discovered in sub-document gives instructions on how to repair a file with this error; if you are not confident of your ability to carry out the procedure, post your file here and someone will have a look at it.

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
venturini
Posts: 6
Joined: Sat Sep 21, 2019 11:00 am

Re: [Solved] Error discovered in sub-document content.xml

Post by venturini »

Hello to everyone. This is my first post, sorry if I am OT.
I have a similar problem described in the initial message. I cannot open a .odt file and the message is "Format error discovered in the file in sub-document content.xml at 2,69554(row,col)"
The file is attached.
Can anyone help me?
I saw the tutorial but I am not able to follow it.
Thanks a lot
Last edited by RoryOF on Sat Sep 21, 2019 11:33 am, edited 4 times in total.
Reason: File removed for confidentiality [RoryOF, Moderator]
macOS Mojave 10.14.5
Apache OpenOffice 4.1.6
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Error discovered in sub-document content.xml

Post by RoryOF »

Attached is the repaired file. Please check that content and formatting are as you require.
Last edited by RoryOF on Sat Sep 21, 2019 11:32 am, edited 2 times in total.
Reason: File removed for confidentiality [RoryOF, Moderator]
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
venturini
Posts: 6
Joined: Sat Sep 21, 2019 11:00 am

Re: [Solved] Error discovered in sub-document content.xml

Post by venturini »

The file is perfect. You were able to recover not only the text but also the format, thanks a lot!
Very quick and efficient.

Now that I have dowloaded it could you please take it out?
macOS Mojave 10.14.5
Apache OpenOffice 4.1.6
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Error discovered in sub-document content.xml

Post by RoryOF »

Just for the record, as some day someone may start to investigate the cause of the error.

The error was the usual multiple comment error near start of the file. I also note that it originated on OO on a Mac - my memory (not checked) is that there are a disproportionate number of Macs producing such errors. No trace of it having been Saved in MS Word format, but Comments had been added by others, whether using OO or MS Word I cannot say.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: [Solved] Error discovered in sub-document content.xml

Post by John_Ha »

This is a bug in AOO, but not in LO, when track changes is ON and a user deletes two comments each of which is attached to a range of characters.

See Issue 128356 - Track Changes and Annotations on text range can cause corruption. Applies to 4.x (all versions?)
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
sonolee
Posts: 1
Joined: Tue Jun 30, 2020 3:51 am

Re: [Solved] Error discovered in sub-document content.xml

Post by sonolee »

HI, i am having the same issue with a file that had previously worked fine. I attempted to follow the guide but am afraid it is a bit above my level. Would you be able to perform the repair on my file as it appears you have some others?

Thank you in advance
Libre office 6.2 on windows 10
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Error discovered in sub-document content.xml

Post by robleyd »

Can you upload your file? See How to attach a document for details regarding attaching a document.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Error discovered in sub-document content.xml

Post by RoryOF »

An uploaded document, or a pointer to a URL of that document on a file sharing service, would allow us assess and fix the error, if that is possible.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
garfield123
Posts: 6
Joined: Fri Jul 24, 2020 12:50 am

Re: [Solved] Error discovered in sub-document content.xml

Post by garfield123 »

Same problem! This is an .odt file that has gone back and forth with a colleague who uses the dreaded MS Word. I saved it after making my own revisions, sent the file to him, and now neither of us can open it. I'm getting this error:

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

I'm too much of a newbie to fix it using any of the guides I see out there, so if anyone has any way to help, I'll be very grateful.
OpenOffice 4.1.7
MacOS 10.15.6
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Error discovered in sub-document content.xml

Post by robleyd »

Can you attach the document here? See my posts above for a link on how to attach documents.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
garfield123
Posts: 6
Joined: Fri Jul 24, 2020 12:50 am

Re: [Solved] Error discovered in sub-document content.xml

Post by garfield123 »

Here's a link to the document. Thank you!
Last edited by garfield123 on Fri Jul 24, 2020 2:11 am, edited 1 time in total.
OpenOffice 4.1.7
MacOS 10.15.6
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Error discovered in sub-document content.xml

Post by robleyd »

Check the attached document - there are 17 pages in it.
 Edit: Attachment removed 
Last edited by robleyd on Fri Jul 24, 2020 2:41 am, edited 1 time in total.
Reason: Remove attachment
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
garfield123
Posts: 6
Joined: Fri Jul 24, 2020 12:50 am

Re: [Solved] Error discovered in sub-document content.xml

Post by garfield123 »

robleyd for the win! Thanks so much. [deleting links now]
OpenOffice 4.1.7
MacOS 10.15.6
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: [Solved] Error discovered in sub-document content.xml

Post by John_Ha »

garfield123 wrote:This is an .odt file that has gone back and forth with a colleague who uses the dreaded MS Word. I saved it after making my own revisions, sent the file to him, and now neither of us can open it.
We now believe this is a bug in AOO but not in LO. It can always be made to happen by deleting two (or more?) comments each attached to a range of text though other things may also cause it. It probably is nothing to do with Word. See Issue 128356 - Track Changes and Annotations on text range can cause corruption. Applies to 4.x (all versions?)
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
rims
Posts: 5
Joined: Wed Dec 02, 2020 5:16 am

Re: [Solved] Error discovered in sub-document content.xml

Post by rims »

Hi, Good day!
I need your help regarding the recovery of my file. I encountered the same error in this thread.
However, my file cannot be attached because it is larger than 128kb. How can I possibly attach it? Please, Thank you.
Win7
Open Office 3.2
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Error discovered in sub-document content.xml

Post by robleyd »

Upload your file to a file sharing service and post the link here. Please ensure that we don't need to log in to the service you choose.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
rims
Posts: 5
Joined: Wed Dec 02, 2020 5:16 am

Re: [Solved] Error discovered in sub-document content.xml

Post by rims »

Pasted above is the link, please.
Thank you so much..
Last edited by rims on Fri Dec 04, 2020 3:29 am, edited 1 time in total.
Win7
Open Office 3.2
rims
Posts: 5
Joined: Wed Dec 02, 2020 5:16 am

Re: [Solved] Error discovered in sub-document content.xml

Post by rims »

I hope these links above will direct you to my corrupted file. Thank you!
Last edited by rims on Fri Dec 04, 2020 3:28 am, edited 1 time in total.
Win7
Open Office 3.2
User avatar
robleyd
Moderator
Posts: 5086
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Error discovered in sub-document content.xml

Post by robleyd »

I have managed to recover some/ all of your data and sent the repaired file to you via the email you used to register here.

NOTE: the email is not public - only as a moderator I have access.

If the file is acceptable you may wish to edit your posts above and remove the links to the file.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
rims
Posts: 5
Joined: Wed Dec 02, 2020 5:16 am

Re: [Solved] Error discovered in sub-document content.xml

Post by rims »

THANK YOU VERY MUCH for resolving this concern. I can now open my file.
Win7
Open Office 3.2
garfield123
Posts: 6
Joined: Fri Jul 24, 2020 12:50 am

Re: [Solved] Error discovered in sub-document content.xml

Post by garfield123 »

I seem to have bumped up against this error once again. Can someone out there try to repair a broken .odt file for me?
OpenOffice 4.1.7
MacOS 10.15.6
FJCC
Moderator
Posts: 9278
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: [Solved] Error discovered in sub-document content.xml

Post by FJCC »

Please post the file here or make it available in some other way such as a cloud drive. To post a file here, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
garfield123
Posts: 6
Joined: Fri Jul 24, 2020 12:50 am

Re: [Solved] Error discovered in sub-document content.xml

Post by garfield123 »

Here it is. Gratitude in advance for your help.
Last edited by garfield123 on Wed Dec 09, 2020 1:31 am, edited 1 time in total.
OpenOffice 4.1.7
MacOS 10.15.6
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Error discovered in sub-document content.xml

Post by Villeroy »

Please avoid comments (annotations) that are assigned to a range of text. Assign annotations to positions.
 Edit: File deleted at user request 
Last edited by Villeroy on Wed Dec 09, 2020 2:33 am, edited 3 times in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: [Solved] Error discovered in sub-document content.xml

Post by John_Ha »

garfield123 wrote:Here it is. Gratitude in advance for your help.
Try this one.

There is a bug in AOO which will corrupt the file if you delete two comments attached to a range of text.

As you and your collaborator use Record Changes and Comments I strongly recommend you swap to LibreOffice where the bug seems to have been fixed.
 Edit: File deleted at user request 
Last edited by John_Ha on Wed Dec 09, 2020 1:54 am, edited 3 times in total.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Locked