Calc keeps crashing, lots of lost work

Discuss the spreadsheet application

Calc keeps crashing, lots of lost work

Postby willsanderson1 » Fri Jan 11, 2019 7:50 pm

Hi.
I've reinstalled OO recently to get rid of a crashing problem. I updated JRE to latest version and it keeps happening.

There doesn't seem to be anything specific that I'm doing. These are very simple spreadsheets with a couple sum formulas. The application freezes and thankfully I can usually take a screenshot and redo the work. Auto saving has been set to every minute in the hopes of mitigating lost work. No avail. Recovery doesn't work either.. "Read-Error. Unknown or unsupported Excel file."

Any help, thoughts or ideas would be appreciated.
Will
OpenOffice 4.1.6 on Windows 10 version 1803
willsanderson1
 
Posts: 2
Joined: Fri Jan 11, 2019 7:36 pm

Re: Calc keeps crashing, lots of lost work

Postby RoryOF » Fri Jan 11, 2019 7:53 pm

This may be a symptom of a recent (within last few months) update of Win 10. Reports were that it caused severe instability of OpenOffice; removal of that update cured the problem, but it automatically reinstalled on later updates. However, more recent reports are that the update responsible has been replaced with an update that does not cause OO instability.

So my advice is that you tell Win 10 to do a complete update so that it is fully updated. How long this will take I cannot say - it may be some hours and several computer restarts.

 Edit: Also, work and Save in .ods format - OO's native spreadsheet format. 
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28567
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc keeps crashing, lots of lost work

Postby John_Ha » Fri Jan 11, 2019 11:20 pm

Strange problems are sometimes fixed by resetting the profile - see Resetting the user profile.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6578
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Calc keeps crashing, lots of lost work

Postby willsanderson1 » Tue Jan 15, 2019 5:47 pm

Thanks so much for your replies. I had seen the part about saving in .ODS format and have changed my behavior. Seems to make a difference.

I'll try the profile reest too.
OpenOffice 4.1.6 on Windows 10 version 1803
willsanderson1
 
Posts: 2
Joined: Fri Jan 11, 2019 7:36 pm

Re: Calc keeps crashing, lots of lost work

Postby RoryOF » Tue Jan 15, 2019 6:25 pm

I would try a full Windows 10 update as well.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28567
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 22 guests