Question

2

How to repair ods files

rated 0 times [ 2] [ 0] / answers: 1 / hits: 9747 / 1 Year ago, thu, march 9, 2023, 9:24:30

I have few ods files but all of a sudden it is not opening. When i open the file i get the following error. Please look at the below snapshot

enter image description here

Error on opening the file with Archive Manager:

enter image description here

karthick@karthick:/media/Datas$ zip -FF data.ods --out repaired_file.ods

Fix archive (-FF) - salvage what can

Found end record (EOCDR) - says expect single disk archive

Scanning for entries...

copying: mimetype  (46 bytes)

copying: Configurations2/statusbar/  (0 bytes)

copying: Configurations2/accelerator/current.xml  (2 bytes)

copying: Configurations2/floater/  (0 bytes)

copying: Configurations2/popupmenu/  (0 bytes)

copying: Configurations2/progressbar/  (0 bytes)

copying: Configurations2/menubar/  (0 bytes)

copying: Configurations2/toolbar/  (0 bytes)

copying: Configurations2/images/Bitmaps/  (0 bytes)

copying: content.xml  

zip warning: no end of stream entry found: content.xml

zip warning: rewinding and scanning for later entries

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

sigtestim

Add To Favorites

Follow

Total Points: 298

Total Questions: 108

Total Answers: 106

Location: Bermuda

Member since Thu, Apr 20, 2023

1 Year ago

answered 1 Year ago otputler · Accepted Answer

ODS files, like all Open Document file types, are just ZIP files. You can try to repair the file using regular tools for repairing ZIPs. For example on the command line:

zip --fixfix file.ods

Beware that you should always operate on a copy of the file. If extracting data works, you might be able to re-assemble the file as a ZIP archive and load it in OpenOffice.org.

Before trying this, you should make sure the file is actually an ODS file. If you run

hexdump -C file.ods | head -1

It should look like this

00000000  50 4b 03 04 14 00 00 08  00 00 a8 a3 d3 3e 85 6c  |PK...........>.l|

That is, it should start with PK.

Also perhaps you can open the file in a different version of OpenOffice.org, or using gnumeric or Google Docs.