Corrupted .ods file

Discuss the spreadsheet application

Corrupted .ods file

Postby Intotherain » Thu May 06, 2021 2:52 pm

Hello, unfortunately I have a corrupt file, I think that it happened yesterday when I had to force a PC reset while it was opened. Unfortunately I don't have a backup, I have already looked for temp files but it didn't work.
I've tried everything I could, failed to zip it and extract, tried many recovery software but nothing worked so far. Openoffice calc just open it blank.
I've saw that you guys helped some users in the past recovering the file, it would be great if you could help me.
Google drive link of the file: https://drive.google.com/file/d/1CCkS0L ... sp=sharing

Thanks a lot.
OpenOffice 4.1.9 on windows 10
Intotherain
 
Posts: 3
Joined: Thu May 06, 2021 2:46 pm

Re: Corrupted .ods file

Postby RoryOF » Thu May 06, 2021 2:58 pm

Your file is badly damaged. I am not expert in recovering Calc files, so leave that (if possible) to those with more expertise on that type of file.

Have you tried using Recuva or PhotoRec to perform an indepth undelete for temporary files?
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32683
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Corrupted .ods file

Postby Intotherain » Thu May 06, 2021 3:05 pm

I've tried Recuva but it didn't help, do you have a legit download link for PhotoRec? The sites I found seems a bit shady
OpenOffice 4.1.9 on windows 10
Intotherain
 
Posts: 3
Joined: Thu May 06, 2021 2:46 pm

Re: Corrupted .ods file

Postby John_Ha » Thu May 06, 2021 4:19 pm

Your file is full of null characters and there is no user data in it.

Clipboard01.png

See Why is my Writer file full of #####? for an explanation of files full of null characters which Writer displays as ######.

See [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and later) to recover previous versions of the file (is there something similar on MacOS and Linux?);

b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted;

d) find any temporary files AOO wrote while you were editing the file but which have not yet been deleted;

e) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. d) and e) will recover your file as it was when you last opened or you last saved it.

If you cannot follow the instructions ask someone with more PC skills to help you. Act quickly - the longer you wait the more likely any temporary files are to be deleted.
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: 8473
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Corrupted .ods file

Postby Intotherain » Fri May 07, 2021 1:12 am

I tried everything, windows restore, looked at every temp files and recuva but nothing worked, I guess I just lost everything :(
Thanks for your help anyway, appreciated.
OpenOffice 4.1.9 on windows 10
Intotherain
 
Posts: 3
Joined: Thu May 06, 2021 2:46 pm

Re: Corrupted .ods file

Postby robleyd » Fri May 07, 2021 1:23 am

For future peace of mind you might consider installing the Timestamped backup extension, which will allow you to make multiple, timestamped backups of your document. Note that this must be invoked separately from your normal Save.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 4034
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests