Page 1 of 1

Open Office File Repair

PostPosted: Tue Feb 14, 2012 5:02 am
by Little_Devil
I just had a file that apparently had a corrupt crc, denoting the file was not recoverable.

This file was saved as a spreadsheet with the file extension of xls, denoting that it was an Excel spreadsheet file. Consequently after trying to recover the file with my own professional file recovery tools, I decided to search and try out many different file recovery programs, which one by one failed. These included Excel file repair programs and Open Office repair utilities.

At this point I was tearing my hair out, since it was a master file, and imputing all the data again would have taken a long time. So I decided to stop using these file repair/recovery programs and read up on how the file was created.

To cut a long story short, in the end I used FF to recover the file. :)

How ? By using the File Open in FF, then instead of opening the file with a program, just saved it with a different file name. Double clicked the saved file, and it instantly opened with Open Office.

Summary: If it looks like you have lost an OO file, try this method first, may save you hours of time and loss of hair :P

Re: Open Office File Repair

PostPosted: Tue Feb 14, 2012 8:43 am
by Deathtaker27
This is why people backup ;)

but also thanks for the information, I'm sure I will need it too some day

Re: Open Office File Repair

PostPosted: Sun Feb 26, 2012 11:14 pm
by Flawless
Deathtaker27 wrote:This is why people backup

Backing up usually occurs with hours or days difference. Backing up every file you might work on is hardly efficient.

Re: Open Office File Repair

PostPosted: Wed Feb 29, 2012 8:30 am
by adz
Flawless wrote:
Deathtaker27 wrote:This is why people backup

Backing up usually occurs with hours or days difference. Backing up every file you might work on is hardly efficient.


Define back up? You could use a CVS/DRCS (aka a repository), allowing you to at least revert back to a previous working version.

Re: Open Office File Repair

PostPosted: Wed Feb 29, 2012 9:35 am
by Little_Devil
The only sure fire way of taking a backup is using a VCS, like tortoise and mercurial or the MS and other offerings.

Apparently the backup in Open Office does not always work or at least keep files correctly, if what you read on some blogs is to be believed, although I tend to think people don't use the backup correctly or actually define a path that is not in the temp folder.