I have a corrupted spreadsheet file which I can't repair

Discuss the spreadsheet application
Post Reply
thenax
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

I have a corrupted spreadsheet file which I can't repair

Post by thenax »

help me!
I searched for free and paid repair sites or programs. I used an online one but it couldn't fix the file.

Someone can help me to recover the here joined file?
thank you
Attachments
SORCE 2021.ods
(27.88 KiB) Downloaded 98 times
openoffice 4.1.9 windows 10
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: corrupted file

Post by floris v »

My archive manager doesn't recognize it as a valid archive, it's also suspiciously small, so it's probably lost. Sorry about that.
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
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: corrupted file

Post by MrProgrammer »

floris v wrote:My archive manager doesn't recognize it as a valid archive, it's also suspiciously small, so it's probably lost.
There is no recoverable data in the file. I hope the OP didn't spend any money on recovery efforts. They were doomed to fail.
[Tutorial] The Dreaded Pound Signs: file reduced to ####
$ # The downloaded file is 28546 characters
$ wc -c <SORCE%202021.ods
   28546
$ # After removing null characters the size is zero, thus the file is 28546 nulls
$ tr -d '\0' <SORCE%202021.ods | wc -c
       0
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
thenax
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

Re: I have a corrupted spreadsheet file which I can't repair

Post by thenax »

thank you everyone.
I didn't find temp files and backup was deactivated :-(
openoffice 4.1.9 windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: I have a corrupted spreadsheet file which I can't repair

Post by RoryOF »

Try an undelete program such as Recuva or PhotoRec; the sooner you do this the better chance of success,
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
thenax
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

Re: I have a corrupted spreadsheet file which I can't repair

Post by thenax »

just tried, but I didn't find any temp files, only the last temp file dated 04/10/2021
openoffice 4.1.9 windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: I have a corrupted spreadsheet file which I can't repair

Post by RoryOF »

That file is at least yesterday's. If you can read/edit it you have only lost a day's work, not the entire work.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
thenax
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

Re: I have a corrupted spreadsheet file which I can't repair

Post by thenax »

...but that temp file is about another ods....not the same that I lost!
openoffice 4.1.9 windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: I have a corrupted spreadsheet file which I can't repair

Post by RoryOF »

The only suggestion I can make is that you tell the undelete program to make an indepth examination of the folder in which the missing file was Saved. What, if anything, you will find, I cannot say.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
thenax
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

Re: I have a corrupted spreadsheet file which I can't repair

Post by thenax »

thank you but the folder is invisible (lost) and so I can only scan f: directory
nothing!
openoffice 4.1.9 windows 10
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I have a corrupted spreadsheet file which I can't repair

Post by John_Ha »

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.
Post Reply