OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to recover CALC file

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
pradhan
General User
General User


Joined: 01 Sep 2006
Posts: 48

PostPosted: Mon Sep 04, 2006 6:59 am    Post subject: How to recover CALC file Reply with quote

I have an important calc file. While using it I closed the prog. CALC by pressing CNTRL + somekey by mistake.

Now I cannot open the fileagain . I get "READING ERROR - ERROR IN FILE FORMAT AT ROW (xx) AND COL (xx).

Can someone help me urgently.

Thanks.
Back to top
View user's profile Send private message
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Mon Sep 04, 2006 9:27 am    Post subject: Re: How to recover CALC file Reply with quote

pradhan wrote:
Can someone help me

Try to unzip the renamed document with 7Zip http://www.7-zip.org/ and then try to repair it:
- http://www.oooforum.org/forum/viewtopic.phtml?t=24208&highlight=pspad+firefox
- http://www.oooforum.org/forum/viewtopic.phtml?t=23146&highlight=pspad+firefox
- http://www.oooforum.org/forum/viewtopic.phtml?t=20840

With kind regards
hol.sten
Back to top
View user's profile Send private message
pradhan
General User
General User


Joined: 01 Sep 2006
Posts: 48

PostPosted: Mon Sep 04, 2006 11:15 pm    Post subject: How do I repair content.xml Reply with quote

Thanks for your reply and the links. I went through all that it didn't help me understand how to repair the Calc file.

My calc file is a 10 sheet file full of formulas that relate between sheets.

I renamed the .ods to .zip - opened with winzip. noe what do I do ?

What do I do with the content.xml file ? How do I locate the position of error ?

Please help, thanks.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Sep 05, 2006 5:49 am    Post subject: Re: How to recover CALC file Reply with quote

As with another similar request in Writer, I'd suggest in future keeping copies elsewhere [e.g. flash drive] if that important to you.

If you have a corrupted file, then there may be no way to determine which cross-links are lost. Being binary, it takes only one shift to the left [missing a single bit] to utterly corrupt a file. If lucky, you can retrieve text, even if resorting to a Hex editor, but formulas are cross-linked, and those links may be irretrievably lost.

Consider what happens with ordinary language with the removal of just one letter:

Cnsiderw hath appensw itho rdinaryl anguagew itht her emovalo fj usto nel etter:

The loss could be anywhere. That does not make it impossible, just perhaps inordinately difficult, and so not worth the effort. It takes much less effort to keep backups.

P.S. If the file is not too personal, and you could make it available for download, I'd at least take a look.

David.
Back to top
View user's profile Send private message
pradhan
General User
General User


Joined: 01 Sep 2006
Posts: 48

PostPosted: Tue Sep 05, 2006 11:09 pm    Post subject: Reply with quote

I have a backup copy which does not contain all the modifications I made in 5 hours of work.
Usually I am prudent.

I'll be happy if you can look into the file. How can I make the file available to you ? I don't have a web_site for downloading. Can you send me your e-mail ?

Thanks for your suggestions.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Wed Sep 06, 2006 1:02 am    Post subject: Reply with quote

You can upload your file to http://www.mytempdir.com/

You will receive a link that others can use to download the file. If you do not wish to make that public, send David a personal message by clicking on the button marked "PM" on his last post.
_________________
search forum by month
Back to top
View user's profile Send private message
pradhan
General User
General User


Joined: 01 Sep 2006
Posts: 48

PostPosted: Wed Sep 06, 2006 7:25 am    Post subject: Reply with quote

I have uploaded the incriminated file here:
http://www.mytempdir.com/913488
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed Sep 06, 2006 9:27 am    Post subject: Reply with quote

pradhan wrote:
I have uploaded the incriminated file here:
http://www.mytempdir.com/913488


I started an initial check, renaming as a ZIP and extracting the "content.xml" file. It seems to be damaged at one point, as seen both at the end of the xml listing, and the source of that in Notebook editor. As I said in my PM reply though, I have just dealt with some maliscious software shortly after I had sent the prior message, and am a little relutant to now play games when the browser gave a message that the "file has been restricted from showing active content that could harm your computer."

It may well be simply due to the coding error, but I'm just too timid at the moment to procede. The spyware I dealt with was quite maliscious and intrusive. "Spybot" by chance took care of it, and even then with some effort, or there would have been a horrendous amount of work to do, or a complete from zero re-start.

Sorry I can't help just now.

David.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Wed Sep 06, 2006 9:25 pm    Post subject: Reply with quote

I was unable to extract or even view content.xml because of the following:
Quote:
bad CRC 128304e7 (should be e4ae0c23)


The CRC error is dealt with in this thread: http://www.oooforum.org/forum/viewtopic.phtml?t=24208
You may need to get one or other of the software programmes mentioned there.

You've probably gone beyond this but the subject is dealt with briefly and generally in an article listed on this page: http://documentation.openoffice.org/HOW_TO/misc/Troubleshooting_guide.html

EDIT: I have opened content.xml with Writer. If someone who understands such matters does so, they may be able to edit the file appropriately.

I also opened the file with Firefox and got this message:
Quote:
XML Parsing Error: prefix not bound to a namespace
Location: <path>/content.xml
Line Number 2, Column 123149:

That may be the first of several errors.
_________________
search forum by month
Back to top
View user's profile Send private message
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Thu Sep 07, 2006 11:34 am    Post subject: Reply with quote

pradhan wrote:
I have uploaded the incriminated file here:
http://www.mytempdir.com/913488

I gave the file a try too. I never had such a corrupted file like that. I have the CRC error too. Although after a single correction at styles.xml, some minor corrections and deleting a big chuck at content.xml it now opens here with several tables. What now? Any address I can send it to?

With kind regards
hol.sten
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
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


Powered by phpBB © 2001, 2005 phpBB Group