I cannot open my spreadsheet

Discuss the spreadsheet application

I cannot open my spreadsheet

Postby bigyin » Thu Mar 10, 2016 10:16 pm

I use Calc as a "To Do" list which holds a record of past activities over several years and future plans including important appointments etc.
I've just tried to open it to do an edit and I was presented with a font choice dialogue. After this it opened a text document filled with the hash character.
When I try "Open With" I get a blank spreadsheet.
This is obviously a major issue for me.
I'm running Win 7.
Thanks.
Open Office Ver 4.0.1
Windows Vista (32 bit)
bigyin
 
Posts: 17
Joined: Sat Nov 09, 2013 4:54 pm

Re: I cannot open my spreadsheet

Postby bigyin » Thu Mar 10, 2016 10:44 pm

It looks as though the file has become corrupted as I can open other files ok. I presume there's no way to repair the corrupt file ?
Open Office Ver 4.0.1
Windows Vista (32 bit)
bigyin
 
Posts: 17
Joined: Sat Nov 09, 2013 4:54 pm

Re: I cannot open my spreadsheet

Postby Hagar Delest » Sun Mar 13, 2016 8:44 pm

Hi and welcome to the forum!

Sadly, quite nothing to do I fear, see: 22 pages term paper replaced with pound signs.

Check the temporary folder of the system (see in OO Tools>Options>OO>Paths). If there are folders like sgmlf.tmp with a file having the same name inside, make a copy of that file, rename it in .ods (I hope you were saving in ODF) and cross your fingers.
Check also the backup folder in case you have a copy there, see: [Tutorial] The OpenOffice User Profile.

If you want to help fix this problem, you can also do this survey created for this very problem: Document Recovery Survey.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28679
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: I cannot open my spreadsheet

Postby bigyin » Sun Mar 13, 2016 9:58 pm

Thanks very much for trying to help. Your description of possible recovery options is I'm afraid, a bit too complex for a layman ( or stupid person) like me.
In the end I deleted and re-installed Open Office but that didn't help. I've since deleted the corrupted file and started a new diary starting the day following the loss. I have however completed the survey to the best of my ability. There was only one question that I couldn't answer.
On reflection, it was probably my own fault for doing a "Force shutdown" when the system appeared to hang for more than five minuted whilst attempting a restart.
Open Office Ver 4.0.1
Windows Vista (32 bit)
bigyin
 
Posts: 17
Joined: Sat Nov 09, 2013 4:54 pm

Re: I cannot open my spreadsheet

Postby Hagar Delest » Tue Mar 15, 2016 10:09 pm

Have you checked the temporary folder? When they are not wiped out, there are still chances to recover the files.
Anyway, backup, backup and backup!
If you've reinstalled, make also sure that the "Always create backup copy" is activated in the Load/Save options.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28679
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: I cannot open my spreadsheet

Postby bigyin » Tue Mar 15, 2016 10:58 pm

Yes, I've checked the temporary folder and there's nothing there.
I've now activated the "Always create backup copy" option so hopefully I won't have the same problem again.
Thanks again for your help.
Open Office Ver 4.0.1
Windows Vista (32 bit)
bigyin
 
Posts: 17
Joined: Sat Nov 09, 2013 4:54 pm

Re: I cannot open my spreadsheet

Postby RoryOF » Tue Mar 15, 2016 11:11 pm

Always take a few seconds longer than you have done before powering down (or sleeping/hibernating) your computer. The OpenOffice file is complex and take slightly longer to write than a flat file. When the process is interrupted such file loss can occur.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30407
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: I cannot open my spreadsheet

Postby bigyin » Wed Mar 16, 2016 12:12 am

I think that's how it happened. I always (usually) do a normal orderly shut down but on that occasion, the shutdown seemed to hang for over five minutes. If it had been the normal night time shut down I'd have left it to finish on it's own but this was a restart and I did a "Force Shutdown". My own fault.
Open Office Ver 4.0.1
Windows Vista (32 bit)
bigyin
 
Posts: 17
Joined: Sat Nov 09, 2013 4:54 pm

Re: I cannot open my spreadsheet

Postby bigyin » Thu Aug 23, 2018 10:39 am

Unfortunately, this has happened again. I first reported this in March 2016 and it's happened a few times since then.
I've noted the comments re shut down etc. but it's only this particular file that's affected (other spreadsheets ok).
I find it hard to accept that this issue which has been reported many times over a long period of time cannot be fixed ?
Open Office Ver 4.0.1
Windows Vista (32 bit)
bigyin
 
Posts: 17
Joined: Sat Nov 09, 2013 4:54 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests