[Hint] How did I fix my ODT file

Discuss the word processor

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

Postby lolindir » Sat Jul 23, 2016 1:02 pm

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
lolindir
 
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Postby RoryOF » Sat Jul 23, 2016 1:22 pm

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.4 on Xubuntu 16.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25088
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby lolindir » Sat Jul 23, 2016 1:35 pm

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
lolindir
 
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Postby acknak » Sat Jul 23, 2016 1:45 pm

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
User avatar
acknak
Moderator
 
Posts: 22614
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Postby lolindir » Sat Jul 23, 2016 2:03 pm

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
lolindir
 
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Postby RoryOF » Sat Jul 23, 2016 2:20 pm

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.4 on Xubuntu 16.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25088
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby lolindir » Sat Jul 23, 2016 2:31 pm

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
lolindir
 
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Postby acknak » Sat Jul 23, 2016 3:40 pm

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
User avatar
acknak
Moderator
 
Posts: 22614
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Postby lolindir » Sat Jul 23, 2016 6:13 pm

Bummer... Anyway, thanks for having a look at it!
LibreOffice 5.1.4.2 / Ubuntu 16.04
lolindir
 
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Postby John_Ha » Sat Jul 23, 2016 7:55 pm

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.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby keme » Sun Jul 24, 2016 10:37 am

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 3.4.1/4.1.2/4.1.3, on Ms Windows 7/10 and Mac OS-X 10.8.5 and 10.11.
LibreOffice 4.3.3.2 on Mepis Antix MX 14
User avatar
keme
Volunteer
 
Posts: 2598
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

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

Postby lolindir » Tue Jul 26, 2016 9:40 pm

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
lolindir
 
Posts: 6
Joined: Sat Jul 23, 2016 12:55 pm

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

Postby ljicpu » Sun Aug 07, 2016 11:49 am

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 22 times
OpenOffice 3.1 on Windows 10
ljicpu
 
Posts: 1
Joined: Sun Aug 07, 2016 11:40 am

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

Postby acknak » Sun Aug 07, 2016 2:02 pm

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
User avatar
acknak
Moderator
 
Posts: 22614
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Postby John_Ha » Sun Aug 07, 2016 2:05 pm

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.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby acknak » Sun Aug 07, 2016 2:30 pm

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
acknak
Moderator
 
Posts: 22614
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

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

Postby RoryOF » Sun Aug 07, 2016 2:43 pm

If so, perhaps best to mention also PhotoRec, as that is cross platform, whereas Recuva is Windows only.
Apache OpenOffice 4.1.4 on Xubuntu 16.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25088
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby John_Ha » Tue Aug 09, 2016 6:23 pm

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.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby floris v » Tue Aug 09, 2016 10:30 pm

Can you split a single post in the middle of a thread?
MS Windows 10 - AOO 4.1.3 - LibreOffice 5.2.3.3
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
floris v
Moderator
 
Posts: 3940
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Postby RoryOF » Tue Aug 09, 2016 10:35 pm

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.4 on Xubuntu 16.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25088
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby floris v » Tue Aug 09, 2016 10:39 pm

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.
MS Windows 10 - AOO 4.1.3 - LibreOffice 5.2.3.3
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
floris v
Moderator
 
Posts: 3940
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Postby RoryOF » Tue Aug 09, 2016 10:43 pm

I'm not going to fiddle with it tonight! Too late to do so.
Apache OpenOffice 4.1.4 on Xubuntu 16.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25088
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby floris v » Tue Aug 09, 2016 10:52 pm

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.
MS Windows 10 - AOO 4.1.3 - LibreOffice 5.2.3.3
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
floris v
Moderator
 
Posts: 3940
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Postby John_Ha » Wed Aug 10, 2016 9:51 am

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 ...
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby John_Ha » Wed Aug 10, 2016 9:52 am

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 ...
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby jmac86 » Wed Aug 17, 2016 2:43 pm

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 37 times
openoffice 4.1 on mac ox 10.9.5
jmac86
 
Posts: 4
Joined: Wed Aug 17, 2016 2:32 pm

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

Postby John_Ha » Wed Aug 17, 2016 3:42 pm

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.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby jmac86 » Wed Aug 17, 2016 3:51 pm

Thanks for trying.

Is there Recuva instructions for mac users?
openoffice 4.1 on mac ox 10.9.5
jmac86
 
Posts: 4
Joined: Wed Aug 17, 2016 2:32 pm

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

Postby John_Ha » Wed Aug 17, 2016 3:58 pm

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.
AOO 4.1.4, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the up to date Writer guide for information. Click the Help button on a pop-up window for extensive help on that function.
John_Ha
Volunteer
 
Posts: 4431
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby jmac86 » Wed Aug 17, 2016 4:07 pm

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
jmac86
 
Posts: 4
Joined: Wed Aug 17, 2016 2:32 pm

PreviousNext

Return to Writer

Who is online

Users browsing this forum: No registered users and 47 guests