[Solved-Partially] Format error discovered in … content.xml

[gekkid]

Hello everyone! Happy to be here...

I have an error in a document that seems quite common... I'm not good with .XML files, so I am attaching the file here and kindly asking for help. The document is important for my work, so I'd truly be grateful

There's a maximum size for the file per attachment: 128 KiB, so I am sharing the document through my drive:

https://drive.google.com/file/d/1asIgK2 ... sp=sharing

Thank you in advance....

Edit: Commercial link deleted - see Links in posts and signatures. [robleyd, moderator]

[Alex1]

Welcome to the forum!
Unlike other files with the same problem, I couldn't extract content.xml from it.
Please check if the file hasn't been truncated during uploading.

[gekkid]

Thank you!

Indeed I have the same issue on my computer before uploading... What now?

[Hagar Delest]

You are toast.
All the data is stored in the content.xml file. If it can't be recovered, then the file is lost, sorry.
Maybe someone will have better luck with extracting it but you should consider redoing it or looking for backups.

Note: your signature is misleading, if 24.8, then it's LibreOffice, not OpenOffice.

[robleyd]

Using Linux I was able to extract the contents of the .ods file with a warning from (un)zip program. However the resulting contents.xml was some 8 Mb and would not display in my XML editor, at which stage I bowed out.

[gekkid]

Thank you for the kind support peepz. Well, I probably have some backups and I can see the data on Google Docs platform. I've updated the Libre Office version.. This has happened before to me so I just hope won't happen again. Is this due to a virus or something?

[gekkid]

You are toast.
All the data is stored in the content.xml file. If it can't be recovered, then the file is lost, sorry.
Maybe someone will have better luck with extracting it but you should consider redoing it or looking for backups.

Note: your signature is misleading, if 24.8, then it's LibreOffice, not OpenOffice.

Which is better by the way, Libre or Open?

[Hagar Delest]

There has been several topics about that issue but never linked with a virus. It's more about malformation of the content.xml file when saved.
I think that all of them occur with AOO but there might be very few with LO.
Honestly, I have switched to LO few years ago because AOO is now almost dead. Most of the active devs have moved to LO and development on AOO is now very limited. The gap with LO is too wide to be recovered. Some still stick to AOO because of it's very stable for them (I have never had any issue with LO). Try and see if it fits your needs.

[robleyd]

If anyone wants to try their luck with the content.xml PM me and I'll make it available. Zipped it is around 522 Kb, unzipped it expands to over 12 Mb.

[Jan_J]

The .ods file is corrupted. When unpacking with command line unzip tool, a message

Code: Select all

inflating: content.xml              bad CRC 8005d210  (should be 695f4517)

shows wrong control sum. This points that some part of the .ods file (maybe even single byte) has been modified, no matter: intentionally, by accident or by media error.
This yields that validity of the content of the unpacked content.xml cannot be guaranteed.

Anyway, after unpacking the content.xml file, when examined by xmllint tool, its first error message

Code: Select all

parser error : attributes construct error
table-cell office:value-type="float" office:value="2014le-cell tabe:style-name="

is related to the text at offset 8151360. There's no evidence that the content remains correct before that point. The type of damage is typical for the modification of the zipped file code after compression. I would not trust this file at all.

[Alex1]

The part after the fragment shown by Jan_J has too many errors, so I had to truncate content.xml. Here's the result:
https://1drv.ms/x/c/f765b63bcd137171/ER ... =true&at=9

[gekkid]

The part after the fragment shown by Jan_J has too many errors, so I had to truncate content.xml. Here's the result:
https://1drv.ms/x/c/f765b63bcd137171/ER ... =true&at=9

Amazing @alex1 ! Awesome..

Thank you so much!!!

Want to share your crypto Public-key so that I may thank you for your service?

You guys are the best! Have a nice day...