| View previous topic :: View next topic |
| Author |
Message |
pradhan
General User
Joined: 01 Sep 2006
Posts: 48
|
 Posted: Mon Sep 04, 2006 6:59 am Post subject: How to recover CALC file |
 |
|
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 |
|
 |
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany
|
|
| Back to top |
|
|
pradhan
General User
Joined: 01 Sep 2006
Posts: 48
|
| Posted: Mon Sep 04, 2006 11:15 pm Post subject: How do I repair content.xml |
|
|
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 |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Tue Sep 05, 2006 5:49 am Post subject: Re: How to recover CALC file |
|
|
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 |
|
|
pradhan
General User
Joined: 01 Sep 2006
Posts: 48
|
| Posted: Tue Sep 05, 2006 11:09 pm Post subject: |
|
|
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 |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Wed Sep 06, 2006 1:02 am Post subject: |
|
|
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 |
|
|
pradhan
General User
Joined: 01 Sep 2006
Posts: 48
|
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Wed Sep 06, 2006 9:27 am Post subject: |
|
|
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 |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Wed Sep 06, 2006 9:25 pm Post subject: |
|
|
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 |
|
|
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany
|
| Posted: Thu Sep 07, 2006 11:34 am Post subject: |
|
|
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 |
|
|
|
