Crashing spreadsheet

Discuss setup / installation issues - Add a spell checker, Language pack?

Crashing spreadsheet

Postby Razorboy66 » Thu Mar 08, 2018 6:07 pm

Hi there- new to this forum but not new to OO have been using for some time- mainly spreadsheets and other stuff. Lately every time I try to insert a line on a spreadsheet it spins and becomes unresponsive. Once i left and went and made a cuppa - came back it was sorted but otherwise i have to force close and then recover to get doc's back. A bit annoying as my spread sheet has a running total some lines down but when i reach that point I have to insert more lines and then bam crash- any advice? I would like to solve this issue.
OpenOffice 4.1.4
Windows 7
Core i5
Razorboy66
 
Posts: 3
Joined: Thu Mar 08, 2018 5:58 pm

Re: Crashing spreadsheet

Postby RoryOF » Thu Mar 08, 2018 6:17 pm

Try: Restart computer, then start TaskManager (Ctrl Shift Esc) and kill any soffice or openoffice processes shown on TM's tabs.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27190
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Postby Razorboy66 » Thu Mar 08, 2018 6:31 pm

Thanks ... I do kill it via task manager but, I don't want to have to do this every time I want to insert a line, that the question I'm looking to answer.
OpenOffice 4.1.4
Windows 7
Core i5
Razorboy66
 
Posts: 3
Joined: Thu Mar 08, 2018 5:58 pm

Re: Crashing spreadsheet

Postby RoryOF » Thu Mar 08, 2018 7:05 pm

Crashing may sometimes be caused by a left-over OO component, hence the use of TM. Having done that, you should also Rename your OO user profile, so that a new one is generated on next start of OO. This cures a lot of unexplained OO problems.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27190
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Postby Razorboy66 » Thu Mar 08, 2018 7:26 pm

Cheers ...where's my user profile? And I take it my documents remain the same? sorry if these are dumb questions.
OpenOffice 4.1.4
Windows 7
Core i5
Razorboy66
 
Posts: 3
Joined: Thu Mar 08, 2018 5:58 pm

Re: Crashing spreadsheet

Postby RoryOF » Thu Mar 08, 2018 7:41 pm

Your documents will remain on the computer in the location in which they were saved, but until reopened and saved will not show up on the Recent Documents list.

Close OpenOffice and the Quickstarter. Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer Address Bar and press Enter. Rename the "user" folder (user.old is good to use). Start OpenOffice.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27190
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Postby LilZebra » Thu Mar 08, 2018 9:33 pm

Razorboy66 wrote:Cheers ...where's my user profile? And I take it my documents remain the same? sorry if these are dumb questions.


ff you select Help and in that menu "Restart in Safe Mode" at least for LibreOffice this will give several options, one of which is to create a New profile.

Image
Last edited by LilZebra on Thu Mar 08, 2018 9:40 pm, edited 1 time in total.
LibreOffice 6.0.2 (Linux Fedora 24 on x86_64) with 'Notebookbar'
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.4
User avatar
LilZebra
 
Posts: 42
Joined: Sun Mar 06, 2016 4:27 pm
Location: Canada

Re: Crashing spreadsheet

Postby RoryOF » Thu Mar 08, 2018 9:39 pm

For information there is no "Safe Mode" in OO.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27190
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Postby LilZebra » Thu Mar 08, 2018 9:45 pm

Oh. There should be. Really useful for getting *Office working again.
LibreOffice 6.0.2 (Linux Fedora 24 on x86_64) with 'Notebookbar'
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.4
User avatar
LilZebra
 
Posts: 42
Joined: Sun Mar 06, 2016 4:27 pm
Location: Canada


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 7 guests