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

Discuss the spreadsheet application

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

Postby thenax » Sat Apr 10, 2021 10:48 pm

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 9 times
openoffice 4.1.9 windows 10
thenax
 
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

Re: corrupted file

Postby floris v » Sat Apr 10, 2021 11:40 pm

My archive manager doesn't recognize it as a valid archive, it's also suspiciously small, so it's probably lost. Sorry about that.
AOO 4.1.6 op Linux Mint
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
Volunteer
 
Posts: 4249
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: corrupted file

Postby MrProgrammer » Sun Apr 11, 2021 12:19 am

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 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3959
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

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

Postby thenax » Sun Apr 11, 2021 11:45 am

thank you everyone.
I didn't find temp files and backup was deactivated :-(
openoffice 4.1.9 windows 10
thenax
 
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

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

Postby RoryOF » Sun Apr 11, 2021 11:48 am

Try an undelete program such as Recuva or PhotoRec; the sooner you do this the better chance of success,
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32401
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby thenax » Sun Apr 11, 2021 11:52 am

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
thenax
 
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

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

Postby RoryOF » Sun Apr 11, 2021 11:55 am

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.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32401
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby thenax » Sun Apr 11, 2021 12:13 pm

...but that temp file is about another ods....not the same that I lost!
openoffice 4.1.9 windows 10
thenax
 
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

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

Postby RoryOF » Sun Apr 11, 2021 12:27 pm

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.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32401
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby thenax » Sun Apr 11, 2021 12:32 pm

thank you but the folder is invisible (lost) and so I can only scan f: directory
nothing!
openoffice 4.1.9 windows 10
thenax
 
Posts: 5
Joined: Sat Apr 10, 2021 10:45 pm

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

Postby John_Ha » Sun Apr 11, 2021 12:35 pm

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: 8329
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: Villeroy and 18 guests