Ask Your Question

Large spreadsheet created with OpenOffice crashes on LibreOffice [closed]

asked 2012-10-31 18:54:23 +0100

Duhhh gravatar image

updated 2015-10-18 22:36:08 +0100

Alex Kemp gravatar image

I created a large spreadsheet on OpenOffice, and wanted to switch to LibreOffice. I can open the spreadsheet, but almost any edit I try (changing a named range, editing text or numbers) causes LibreOffice to crash and recover the spreadsheet. The spreadsheet is very large, so it's hard to find out if there is one cause or many for the crash. I've opened the spreadsheet with LO, then saved it immediately, but when I re-open, I can't do much before it crashes. Is there any way to narrow down what is causing the crash?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 22:36:34.266499


OS ? LO and OO versions ? Format of the file ? And without a link to the file, nobody can try to understand what happens.

Jean-Baptiste FAURE gravatar imageJean-Baptiste FAURE ( 2012-10-31 19:44:25 +0100 )edit

OS is Windows XP, LO is, OO version is current. File is an .ODS. I could upload the file, but was going to try and narrow the problem down first. I tried paring the file down to see if I could come up with a testcase that doesn't rely on a huge spreadsheet, but the problem goes away.

Duhhh gravatar imageDuhhh ( 2012-10-31 22:48:52 +0100 )edit

I'm not looking to have someone debug it for me, I was wondering how I'd go about gathering some info from the crash to narrow it down myself.

Duhhh gravatar imageDuhhh ( 2012-10-31 22:52:09 +0100 )edit

I will try to upgrade LibO. I am hesitant to report a bug, because I can't send the spreadsheet (private data), and almost anything crashes it. If I go back to OO and simplify the spreadsheet, going back to LibO causes the bug to go away. I'll see what I can do. Yes, this works on Apache OO 3.4.1

Duhhh gravatar imageDuhhh ( 2012-11-01 18:02:15 +0100 )edit

Please, try with LO 3.6.3 which has just been released.

Jean-Baptiste FAURE gravatar imageJean-Baptiste FAURE ( 2012-11-01 19:07:57 +0100 )edit

After upgrade to the latest LibO version try to reset user profile as decribed here It helps in such strange situations with unexplained faults.

Timon gravatar imageTimon ( 2012-11-02 05:51:14 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-11-01 07:20:58 +0100

Timon gravatar image

First of all, I recommend you to upgrade to final LibO (or 3.6.3 RC 2 - in a few days this version will become final release). What means "OO version is current"? Current version is Apache Open Office 3.4.1. If you use other (older) OO version, then upgrade to latest. May be problem is in OO. Sometimes such problems may occur. Please report a bug with detailed description, LibO, AOO and OS versions, example files and screenshots (if available) and specify "regression from AOO 3.4.1 (or specify what version of OO you use)"

edit flag offensive delete link more

answered 2012-11-02 04:46:03 +0100

vojo gravatar image

guys...why would suggest upgrading to 3.6.x.....3.6.x has a whole bunch of general/basicstability problems things like file association under windows gets messed up, cant launch in place, etc. 3.5.6 works real well.

edit flag offensive delete link more


3.5.6 is a very problem version, especially when working with complex MSO documents. In some cases documents become unreadable. Migration to 3.6.x fixed all that problems for me.

Timon gravatar imageTimon ( 2012-11-02 05:38:17 +0100 )edit

@vojo: You can't say that files association is a stability problem. If you are not able to restore files association, you should learn how to use of your OS. It is a basic action for who has the admin rights to install softwares.

Jean-Baptiste FAURE gravatar imageJean-Baptiste FAURE ( 2012-11-02 07:21:50 +0100 )edit

Question Tools

1 follower


Asked: 2012-10-31 18:54:23 +0100

Seen: 1,976 times

Last updated: Nov 02 '12