Brian, Thank you for the clear and detailed response to my query. Even
when I do not need the information you supply it is informative, giving
insight to the workings of OOo.
Exactly!
Try this:
o Take a copy of your document, so that you don't destroy the original.
o Rename the file to change its extension from .ods to .zip.
o Double-click the .zip file to get Windows to unzip it.
o Open the content.xml file you will find in the archive using a
plain text editor.
o Experiment with editing the file to see if you can find and perhaps
delete the part containing the error.
I followed your suggestion to this point of opening the .xml file with
the text editor, but that was way over my head. It contained 30 rows of
1024 columns and the 31st had 600 and a few. The message said the error
was at 2,31029(row, col). One thought was row 23 column 1029, but they
only went to 1024. So possibly row 24 column 5. That did not seem right
or look promising. Or row 2 and count 31029 from there. I haven't looked
there yet.
Note that anything that you get will not be reliable, and you will
have to check it thoroughly. You may get some data, but you would
probably have to create any formulae anew if they were to be relied upon.
Of course, the quicker method is probably to go back to your most
recent back-up copy of the file and repeat your work from there. Er,
you do keep back-ups?
I trust this helps.
I did have a back up file, which I accidentally deleted. However, today
on the way home from work I remembered a program that recovers deleted
files. Which I downloaded, installed and the program was running while I
was working through your suggestion. The first time it did not recover
the file. It had a deep search feature which turned up more files that
had only numbers for names. Scanning them I remembered most of my files
are .odt whereas the file I needed was .ods. First one I found was a
working copy of the deleted file.
Again, thank you for the assistance. I may play around with your
suggestion, when I have some time.
Julio Sotolongo
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org