Editing contents of an ODS file...

users
#1

Hi!

I have a broken ODS file. LibreOffice can't repair it.

When opening the ODS file in an archiver I can see that the directory
META-INF contains a vastly corrupted file. The rest of the files
inside seem OK.

So I'm tempted to remove the META-INF directory and see if I can open the file.

Unfortunately 7--zip let's me open the ODF file, and even extract its
contents... but not write the updated archive.

Any idea how I can do that?

Thanks!

Gilles

#2

Hi Gilles,

Hi!

I have a broken ODS file. LibreOffice can't repair it.

When opening the ODS file in an archiver I can see that the directory
META-INF contains a vastly corrupted file. The rest of the files
inside seem OK.

So I'm tempted to remove the META-INF directory and see if I can open the file.

you cannot remove it, it has to be there

Unfortunately 7--zip let's me open the ODF file, and even extract its
contents... but not write the updated archive.

See Regina's answer in this thread, and also her hint at the end:
https://ask.libreoffice.org/t/how-can-i-uncompress-a-libreoffice-document-to-get-its-xml-internals-then-make-a-new-document-from-them/59721/11

Cheers
Sophie

#3

Merci Sophie!

So I played with that. But it happens that the content.xml file itself
is too badly corrupted for me to recover it. :frowning:

Thanks! At least I learned how to unpack and ODF file... check the
content... and repack the file to a working version... But the content
was too damaged this time... I'll know next time.

Gilles