[Hint] How did I fix my ODT file

Discuss the word processor
lolindir
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Post by lolindir »

Hi guys,

I have a corrupt ODS file which I am not able to recover. There seems to be still valid data inside the file, but the file header is corrupt (= it does not start with the required hex codes 50 4b 03 04 14 00 00 00). If I open the file inside a hex editor, I however see what seems to be (a part of) valid data (= the file does not contain '00' entries only).
Is there a way to recover the file? How can I do this?

(Since the file header seems to be corrupt, I cannot open or recover the file with an archive program like 7-zip.)

Many thank for your help8
LibreOffice 5.1.4.2 / Ubuntu 16.04
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

I would waste no time on the damaged file. I doubt anything can be recovered from it.
To try and recover your file, you should look in the backup and temporary directories pointed to by /Tools /Options /OpenOffice : Paths. Rename any files in those to type .odt (or whatever file type you were using) and see if they contain your data. Download Recuva or PhotoRec (only one needed) and let it do an indepth recovery of deleted files on your computer. You may get a file containing some or all of your data (or not).
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
lolindir
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Post by lolindir »

Hi all,

I have a corrupt ODS file. The file header seems to be corrupt (when opening in a HEX editor, the file does not start with 50 4b 03 04 14 00 00 08). As a consequence I also cannot open the file with a file archive manager (like 7-zip).
The file however seems to contain data (it's not a file with only '00' entries).

Is there a way to recover the file?

Many thanks for your help!
LibreOffice 5.1.4.2 / Ubuntu 16.04
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Post by acknak »

lolindir wrote:... Is there a way to recover the file? ...
Try RoryOF's suggestion to recover a copy from the filesystem.

On rare occasions, the text can be recovered from a damaged ZIP but I the only way to know is to examine the file. You can attach the damaged file here, or send me a copy (email or PM buttons at right).
AOO4/LO5 • Linux • Fedora 23
lolindir
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Post by lolindir »

Hi,

Thanks for your fast reply!
Unfortunately a recovery from the file system will not be possible I'm afraid: the file stands on a NAS :/
I have sent you a copy of the file via PM. Many thanks in advance for your help and time!
Last edited by lolindir on Sat Jul 23, 2016 2:26 pm, edited 1 time in total.
LibreOffice 5.1.4.2 / Ubuntu 16.04
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

Search the workstation that accessed the file, as it is there temporary copies may have been made. The sooner this is done the better.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
lolindir
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Post by lolindir »

Hi,

I've done this already, but unfortunately I cannot find any copy back. It's an Ubuntu machine (from my girlfriend). Cannot find a copy in the tmp folder, nor can I find it anywhere else on the file system :(
I've activated now the 'create backup' option in Calc, which should prevent this in future (this is unfortunately not solving the current problem).

I've just heard there was apparently a short power cut yesterday, before the problem occurred, during a thunderstorm. Might be the cause of the problem I'm afraid...
LibreOffice 5.1.4.2 / Ubuntu 16.04
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Post by acknak »

Sorry, the zip archive is missing most of the data; there's no trace of the content.xml entry. I don't know of anything else to try.

Sorry I couldn't help.
AOO4/LO5 • Linux • Fedora 23
lolindir
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Post by lolindir »

Bummer... Anyway, thanks for having a look at it!
LibreOffice 5.1.4.2 / Ubuntu 16.04
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

See Using Recuva to un-delete Writer temporary files for help recovering the temporary files which Writer wrote while you were editing the document, and then deleted when Writer was closed.
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.
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

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

Post by keme »

Your NAS may have a rollback option, if a working copy of the file was ever stored there.

Those good old Novell file servers had a salvage utility, and the file system would always use some of the LRU blocks (Least Recently Used) when it required additional storage space.

FreeNAS has a snapshot option. If a snapshot has been taken recently, a rollback may be possible.

Search the web with keywords "salvage", "recover" or "rollback" and the name of your NAS system.
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
lolindir
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Post by lolindir »

Hi all,

Thanks for the suggestions. I had a backup of the file from 2 months ago. We've used the backup and extended it with the missing informations.
Lessons learned: make regular backups ;)

Have a nice evening!
LibreOffice 5.1.4.2 / Ubuntu 16.04
ljicpu
Posts: 1
Joined: Sun Aug 07, 2016 11:40 am

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

Post by ljicpu »

Hello ,
I have a big problem. I was working on my .ods file and power went down. I didnt had backup on. The file is corrupted and i cant open it now. I tried every solution posted on this forum and none worked.
Can someone try to help me to repair the .ods file ill upload it here
Or atleast check it and tell me is there even any chance to save the file

Thank you
Attachments
darko.ods
(28.92 KiB) Downloaded 3202 times
OpenOffice 3.1 on Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Post by acknak »

Sorry, the file contains nothing but zeroes. There's no recoverable data there.

You'll have to try and recover a temporary copy of the file; there should be suggestions about that here somewhere.
AOO4/LO5 • Linux • Fedora 23
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

See Using Recuva to un-delete Writer temporary files for help recovering the temporary files which Writer wrote while you were editing the document, and then deleted when Writer was closed.
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.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Post by acknak »

Thanks, John. I forgot you had put that nice write-up together—bookmarked it!

What do you think about splitting that post off into a tutorial?
AOO4/LO5 • Linux • Fedora 23
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

If so, perhaps best to mention also PhotoRec, as that is cross platform, whereas Recuva is Windows only.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

acknak wrote: What do you think about splitting that post off into a tutorial
acknak

It is on my list of things to do as soon as i get a moment. I started doing it a week or three back but it is somewhat more than a mere copy and paste.
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.
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Post by floris v »

Can you split a single post in the middle of a thread?
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

You could split the tread from that point, then split the new thread after the target post and merge it back to the original. Easier to Edit the target post and copy/Paste to the desired location or to a new thread.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Post by floris v »

There is a Move posts option in the drop-down when you have ticked one or more posts in Split topic. I wonder what it does.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Post by RoryOF »

I'm not going to fiddle with it tonight! Too late to do so.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Post by floris v »

You can do it with Move posts. Tried it in the Dutch forum. Downside is that the post in the original topic will get lost there. In this case that may not be a problem.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

Thanks for the suggestions. What I think is easiest is to edit the post and copy and paste into a tutorial post. I need to do some rewriting to merge all the posts I refer to ...
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.
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

Thanks for the suggestions. What I think is easiest is to edit the post and copy and paste into a tutorial post. I need to do some rewriting to merge all the posts I refer to ...
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.
jmac86
Posts: 4
Joined: Wed Aug 17, 2016 2:32 pm

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

Post by jmac86 »

Hi everyone,

Spreadsheet seems corrupted, asking for filter to open. None work. Don't really understand how to get it back to .xls file or the steps to get the content. Says that the document has 2kb of data which i don't understand as I've used this document over the past 2 years to update information. Anyone that can recover any data from this will save me hours or work. Much appreciated for your time!
Attachments
WEDDING SPREADSHEET 2.ods
(1.5 KiB) Downloaded 3161 times
openoffice 4.1 on mac ox 10.9.5
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

Sorry, your file is full of zeros - there is no data in it and nothing can be recovered from it.

Did the PC crash or hang while you were editing the file? Or were youe diting a fuile on a USB memory stick which you removed too quickly? You may have slammed the laptop lid shut too quickly - that seems to cause it.

See Using Recuva to un-delete Writer temporary files for help recovering the temporary files which, in your case, Calc wrote while you were editing the spreadsheet, and then deleted when Calc was closed. Read .ods for .odt, and read .xls for .doc.
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.
jmac86
Posts: 4
Joined: Wed Aug 17, 2016 2:32 pm

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

Post by jmac86 »

Thanks for trying.

Is there Recuva instructions for mac users?
openoffice 4.1 on mac ox 10.9.5
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Post by John_Ha »

jmac86 wrote:Is there Recuva instructions for mac users?
No - not least because I don't have access to a Mac. But the idea is exactly the same

1 Locate the ...\Temp folder via Preferences > OpenOffice > Paths ...

2 Make sure you can see the ...\Temp folder and the files in it. It would be useful to create a new document and watch the files being created in ...\Temp so you understand what you are looking for.

3 Download a "file undelete" utility for Mac and use it to un-delete the temporary files.
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.
jmac86
Posts: 4
Joined: Wed Aug 17, 2016 2:32 pm

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

Post by jmac86 »

OK thanks, I'll try that.

The original document was used between 3 computers from dropbox. Do you know if dropbox stores previous copies of files?
openoffice 4.1 on mac ox 10.9.5
Post Reply