Crashing spreadsheet

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
Razorboy66
Posts: 3
Joined: Thu Mar 08, 2018 5:58 pm

Crashing spreadsheet

Post by Razorboy66 »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Post by RoryOF »

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.15 on Xubuntu 22.04.4 LTS
Razorboy66
Posts: 3
Joined: Thu Mar 08, 2018 5:58 pm

Re: Crashing spreadsheet

Post by Razorboy66 »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Post by RoryOF »

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.15 on Xubuntu 22.04.4 LTS
Razorboy66
Posts: 3
Joined: Thu Mar 08, 2018 5:58 pm

Re: Crashing spreadsheet

Post by Razorboy66 »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Post by RoryOF »

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.15 on Xubuntu 22.04.4 LTS
User avatar
LilZebra
Posts: 43
Joined: Sun Mar 06, 2016 4:27 pm
Location: Canada

Re: Crashing spreadsheet

Post by LilZebra »

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.1.3.2 (Linux Fedora 29 on x86_64) with 'Notebookbar'
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.5.0
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Crashing spreadsheet

Post by RoryOF »

For information there is no "Safe Mode" in OO.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
LilZebra
Posts: 43
Joined: Sun Mar 06, 2016 4:27 pm
Location: Canada

Re: Crashing spreadsheet

Post by LilZebra »

Oh. There should be. Really useful for getting *Office working again.
LibreOffice 6.1.3.2 (Linux Fedora 29 on x86_64) with 'Notebookbar'
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.5.0
Post Reply