[Solved] Corrupt ODS file

Discuss the spreadsheet application
Post Reply
greencafe24
Posts: 2
Joined: Wed Sep 15, 2021 9:37 am

[Solved] Corrupt ODS file

Post by greencafe24 »

Hi,

Hoping someone can help me recover my ODS file. I've tried the ZIP conversion method but doesn't seem to have worked for me.

Any help greatly appreciated

Thanks
Attachments
messages.ods
(14.28 KiB) Downloaded 143 times
Last edited by Hagar Delest on Thu Sep 16, 2021 7:55 am, edited 1 time in total.
Reason: tagged solved.
OpenOffice 4.1 on Windows 10
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Corrupt ODS file

Post by robleyd »

Not sure how well I've done with this; please check it over and see how it looks.
Attachments
messages_fixed.ods
(10.98 KiB) Downloaded 131 times
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
greencafe24
Posts: 2
Joined: Wed Sep 15, 2021 9:37 am

Re: Corrupt ODS file

Post by greencafe24 »

That's brilliant @robleyd. Thanks so much :)
OpenOffice 4.1 on Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Corrupt ODS file

Post by RoryOF »

I didn't get anywhere with fixing the file - my attempt gave many knock-on errors, which in turn gave other errors. My concern is that there may possibly be content omitted, judging by the size difference between the original file and robleyd's corrected version. I advise waiting for another correction version before deciding that the entire content is present.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Corrupt ODS file

Post by robleyd »

I suspect that may be a factor of the compression software I used (whatever Dolphin uses)?
 Edit: Possibly Ark - I re-created the archive using Ark and got an identically sized file. 
The original, damaged content.xml was 190.6Kb and the repaired version 188.3Kb which seems not an unreasonable difference, as I removed some tens (so many I lost count) of duplicate attributes like table:content-validation-name="valnn".

But of course a close check is warranted.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Corrupt ODS file

Post by RoryOF »

OK - I didn't consider differing compression utilities.

I was getting many duplicate attributes, as you indicate; in early morning my brain is not fully in gear and breakfast is more important, so I abandoned my repair attempt.

Your figure for the sizes of content.xml pre/post repair looks good for the integrity of the content.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply