Thanks CPH, & to [EMAIL PROTECTED] for CCing me on a reply to a similar thread.
Unfortunately the spreadsheet had been saved in Star Office's SDC format, not
OO. I haven't yet migrated to OO on all platforms, and as such I'm limited to
using the lowest common denominator when it comes to file formats.
In any case, it wouldn't have mattered.
I'm not sure of the ~exact~ chain of events, but it appears as though a
recently installed VFAT driver did a nasty and (among other things) unsynched
the working copy of the FAT from the backup. Once I managed to get the
filesystem back in to a useable state, I discovered that all that was left of
the document was the normal spreadsheet header, followed by roughly 3MB of null
characters.
:sigh: Looks like it's time to play data entry clerk for a bit. ...and yes,
this time I've paranoidly ensured that "create backup" is enabled in every
version of OO or SO that I use, under every platform. :-)
-d.
>>> [EMAIL PROTECTED] 2005/10/13 3:43:47 pm >>>
On Tue September 13 2005 13:55, Don Guy wrote:
> Hi,
>
> Is there any such animal as a tool which will attempt to recover data from
> a corrupted spreadsheet? A glitch of unknown origin produced a variety of
> "invalid file format" errors when I saved a file last night, and now
> neither OO nor Star Office will open it. No, I wasn't smart enough to have
> the "save backup copy" option enabled.
>
> I'd really rather ~not~ reconstruct two months of financial data for a
> small business from paper records if I can avoid it. :-/
Hi Don,
You can open an SXC (or any OpenOffice.org native file) and examine it's
"guts" quite easily. This can also allow you to recover data and the files.
Also if you are carefull enough you can recover the data.
To look at the guts of the file simply unzip the file, and then have a look at
contents.xml file to see your data. You can edit this- very carefully - and
rezip it again afterwards.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
