Spreadsheet crashed and won't recover

Discuss the spreadsheet application

Spreadsheet crashed and won't recover

Postby PEZASN » Fri Apr 24, 2020 8:48 am

Hello,

I was using OpenOffice 4.1.6 (on Windows 10 Home) and was working on a spreadsheet.

I was saving the file as xls. The file crashed and OpenOffice cannot open, or recover it.

I am attaching the spreadsheet. Any ideas how/if I could recover this?
Attachments
Req #02 200229 Issued G702_703.xls
(1.5 KiB) Downloaded 13 times
Last edited by MrProgrammer on Fri Apr 24, 2020 8:27 pm, edited 1 time in total.
Reason: Moved topic from Beginners forum to Calc
OpenOffice 4.1.7 on Windows 10 Home Version
PEZASN
 
Posts: 2
Joined: Fri Apr 24, 2020 8:24 am

Re: Spreadsheet crashed and won't recover

Postby robleyd » Fri Apr 24, 2020 9:08 am

There appears to be nothing salvageable in that file. You might try [Tutorial] How to find and un-delete AOO temporary files - maybe you can recover something that way. In future save your documents in Open Document format, not MS formats. Only save to foreign formats if you absolutely have to give someone a foreign format.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3458
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Spreadsheet crashed and won't recover

Postby PEZASN » Fri Apr 24, 2020 9:32 am

I was afraid of that... thank you anyway.
OpenOffice 4.1.7 on Windows 10 Home Version
PEZASN
 
Posts: 2
Joined: Fri Apr 24, 2020 8:24 am

Re: Spreadsheet crashed and won't recover

Postby robleyd » Fri Apr 24, 2020 9:55 am

Seeing you are using Windows, the advice in the tutorial about Previous Versions might be useful.

May I also suggest you consider some kind of backup strategy. For Calc and Writer, the Time stamped backup extension is useful.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3458
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: Bill, GVS and 23 guests