Recovering Data

[stubble]

I'm new to OpenOffice (2.0). I've been working on a spreadsheet for about 6+ hours. I saw the spreadsheet saving my data at regular intervals. I inadvertantly exited the spreadsheet without saving my data. Now when I load the spreadsheet again, it (obviously) doesn't recover from where I left off. I've found the spreadsheet .dat file and unerased it immediately (so it should be good). I can't find a way to import this back into my spreadsheet. Is there a way to do this? What other files would I need to unerase in order for OO to recover this .dat file?

[BookLady]

If this is under XP go to
C:\Documents and Settings\YourName\Application Data\OpenOffice.org2\user\backup

Then look for files with the same name or at the correct time. Simply double click to open and then save under a new name.

[stubble]

Thank you for your help BookLady,

I'm not using XP but ancient IBM OS/2 (as updated by eComStation), but with your guidance I found the files you referred to.

In the \backup\ folder all the files were the same name as the .xls sheet and deleted. I undeleted just the largest of those files. Presumeably, all the rest are just earlier backups of the same file.

I also found the file RECOVERY.XCU in a different folder and recovered that and restored it over the default file.

When I load OO it tries to recover the file, says it succeeded, but there's no data in there. Now, it is possible that the .DAT file is corrupt, but I wouldn't call that first since I recovered it immediately after a reboot, with sufficient space on the boot drive for it not to be overwritten by anything.

So what are the other possibilities?

1) Are there any more files I need to recover besides \backup\spreadsheet.dat and recovery.xcu?

2) The .dat file I unerased had a truncated filename. What should this .dat file's name be exactly? The spreadsheet name with a .dat extension? Or something else? Is the filename case sensitive? If yes, what should the case be?

3) Should I edit the recovery.xcu in any way? This is what it looks like...

<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlns:oor="http://openoffice.org/2001/registry" xmlns:xs="http://www.w3.org/2001/XMLSchema" oor:name="Recovery" oor:package="org.openoffice.Office">
<node oor:name="RecoveryList">
<node oor:name="recovery_item_1" oor:op="replace">
<prop oor:name="DocumentState" oor:type="xs:int">
<value>0</value>
</prop>
<prop oor:name="Filter" oor:type="xs:string">
<value>MS Excel 97</value>
</prop>
<prop oor:name="Module" oor:type="xs:string">
<value>com.sun.star.sheet.SpreadsheetDocument</value>
</prop>
<prop oor:name="OriginalURL" oor:type="xs:string">
<value>file:///E:/var/temp/sedoexcelsheetenglish.xls</value>
</prop>
<prop oor:name="TempURL" oor:type="xs:string">
<value/>
</prop>
<prop oor:name="TemplateURL" oor:type="xs:string">
<value/>
</prop>
<prop oor:name="Title" oor:type="xs:string">
<value>sedoexcelsheetenglish - OpenOffice.org Calc</value>
</prop>
</node>
<node oor:name="recovery_item_2" oor:op="remove"/>
<node oor:name="recovery_item_3" oor:op="remove"/>
<node oor:name="recovery_item_4" oor:op="remove"/>
</node>
<node oor:name="RecoveryInfo">
<prop oor:name="Crashed" oor:type="xs:boolean">
<value>true</value>
</prop>
</node>
</oor:component-data>

4) Any other possibilities?

I'd really like to get my data back because it was boring data input where I had make 3 decisions from a large lookup table per entry and represents about 1/3rd of the total work I need to do on this spreadsheet (just so you hear my pain at losing the data)

Thanks

[stubble]

Any further ideas? Anyone?