Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Thu 23 Oct 2014, 15:57
All times are UTC - 4
 Forum index » House Training » Users ( For the regulars )
Corrupt Spreadsheet
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [3 Posts]  
Author Message
davec60

Joined: 14 Sep 2012
Posts: 22

PostPosted: Fri 18 Jan 2013, 04:13    Post subject:  Corrupt Spreadsheet
Subject description: How can I repair or extract data from a corrupt spreadsheet?
 

I have a Spreadsheet file originally created with Gnumeric (in Puppy Linux) but subsequently saved as as an .xls file. It has opened and functioned perfectly well for several weeks but has now just suddenly decided not to open in either Gnumeric (in Puppy) or with LibreOffice(in CorePlus) ie. nothing happens when I (double)click on the file in the File Manager and it won't open from the terminal or from within any relevant spreadsheet program either. The 'Properties' indicate that the 'contents include: CDF V2 Document, corrupt: Can't read SAT'; (using 'file' in the terminal produces the same message).
I have tried copying the file elsewhere and also tried to change the permissions (by right-clicking the file and via the terminal) but only manage to get a message back saying 'Read-only file system'.
I have also attempted to repair the file and/or extract the data in Microsoft Excel (on a borrowed computer) but that has also failed. I have also not been able to rename it (eg. as a .xml file to try to get it to open in a browser). I was connected to the internet with this file open immediately before I last used and saved it - it may be that someone has well and truly 'done a number' on it - it was the single most important file I had. Quite a coincidence. (Incidentally I have tried to see what Testdisk could do to help but (as usual) had no luck in getting Testdisk to do anything with it. Also, the problem file is on an USB but the rest of the files on the USB seem to be OK. The problem file won't even copy or move to my hard drive or anywhere else).
I wonder whether anyone can please throw any light on how I may now be able to repair the file and/or salvage the data (using Linux).
Thanks,
dave
Back to top
View user's profile Send private message 
ICPUG

Joined: 24 Jul 2005
Posts: 1290
Location: UK

PostPosted: Fri 18 Jan 2013, 08:59    Post subject:  

Files can get corrupt for any number of reasons. That is why if you have really important data you should have a backup strategy! You will in future. I would suggest backing up whatever else is on that USB in case the media is starting to fail.

If you cannot copy or move the file it sounds like it cannot be read and is really corrupt. Do not do anything that will write anything to the USB device until you have recovered your data. If it were me I would try one of two approaches:

(a) use a binary viewer (?) or text file viewer (geany?) to see if I can see any info worth preserving. It will probably be all gobble-de-gook though.

(b) use a file undelete tool to see if some previous versions that have been saved are still available on the drive which can be recovered and viewed. If so you may be able to get the bulk of your data back and you can proceed to work out what was added/amended since it was saved. Unfortunately, I don't know what tool exists for Puppy. Sticking Linux File recovery into Google shows many options. I have seen Photorec mentioned amongst the Google references and in magazines but don't know if it works with Puppy.

My current favourite using Windows is Recuva.

If you see a file to recover then recover it to somewhere else, not the USB device. Only when you are satisfied you have got your data back, or as much as you are going to get, should you consider using the USB device again.
Back to top
View user's profile Send private message 
davec60

Joined: 14 Sep 2012
Posts: 22

PostPosted: Sat 19 Jan 2013, 05:31    Post subject: Corrupt Spreadsheet  

Thanks for your consideration of the problem. I have just managed to recover a very recent copy of the spreadsheet using Photorec and that will be sufficient. I will bear in mind your advice for the future. Problem solved.
dave
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 1 [3 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » House Training » Users ( For the regulars )
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0507s ][ Queries: 12 (0.0091s) ][ GZIP on ]