Ask Your Question
0

Calc crashes when inserting/deleting row(s) [closed]

asked 2012-04-07 13:46:58 +0200

anonymous user

Anonymous

It's a problem that I encounter already for a long time, also with OpenOffice. My Calc workbook sometimes crashes when I insert one or more rows. Or when I delete one or more rows. Lately it got worse and crashes happens quite often.

I started searching for errors and finally started deleting sheets until the problem disappeared. Well, the crashing stopped when I deleted a sheet with about 400 sumproduct-functions in it. Now I think that the sumproduct-function is to "blame" because when I keep the sheet, but just delete the sumproduct-functions, the crashing of Calc did not occur. Keeping a few of the sumproduct-functions in the sheet was also OK, but Calc has problems with more than a few sumproduct-functions...

My sumproduct-function looks as follows: =SUMPRODUCT((Range1="Q1"),(Range2=$B47),Range3)

Any ideas for improvement, or is it a Calc bug?

Jaap

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-15 21:43:39.527759

Comments

Can you provide a sample file? I don't understand why your SUMPRODUCT formula points to a range with a single cell...

Pedro gravatar imagePedro ( 2012-04-07 15:33:38 +0200 )edit

4 Answers

Sort by » oldest newest most voted
0

answered 2012-04-07 17:34:08 +0200

Jaap gravatar image

Sorry, I know it is difficult to help me in this way, but there is too much private data in it :-( I'll try to clean it up and put the file in the post here. Hopefully tomorrow.

It googled for a replacement of the sumproduct-function and replaced all of them by: {=SUM(IF(Range1="Q1",IF(Range2=$B47,Range3)))} (entered as an array). Now the crashes do not occur anymore. So, I guess it is a LO-bug.

Jaap

edit flag offensive delete link more

Comments

Per @moggi's comment below this was indeed a bug: "Problem is fixed in 3.5.2. We used the wrong ScDBData in cell updates." (I'm marking this answer as correct as it also includes @Jaap's workaround)

qubit gravatar imagequbit ( 2013-01-26 18:18:47 +0200 )edit
1

answered 2012-04-14 12:02:07 +0200

Jaap gravatar image

@moggi: I'm using 3.5.2.2 and it is not solved. Errors in the "cell updates" could be a cause, because sometimes after recovery there is a "half row" inserted.

Jaap

edit flag offensive delete link more

Comments

Then please file a bug report and attach a test document. Please be as specific as possible.

moggi gravatar imagemoggi ( 2012-04-19 01:03:03 +0200 )edit
0

answered 2012-04-07 16:46:21 +0200

m.a.riosv gravatar image

Is it the file an xls file?. Try to find with the navigator (F5) for hidden object, maybe in your source copy range.

edit flag offensive delete link more
0

answered 2012-04-08 08:55:15 +0200

Jaap gravatar image

updated 2012-04-08 08:58:50 +0200

@mariosv: No, it's not an xls file but an ods file. I created it in OO a few years ago. Navigator did reveal any hidden objects. I tried to add an image (jpg) of the navigator but got an error "TypeError: data is undefined".

@Pedro: I tried to clean all the personal data from the file so I could post it here. But a strange thing happened: the defined range names disappeared and the sumproduct-functions (which use these defined names) did not yield any results. Inserting/deleting rows in that situation was without problems. So, not a very reproducible bug... I'm sorry I can not post the buggy file here.

What I also tried was to replace all defined range names by their actual ranges (like: $Jnl.$K$3:$K$301). But crashes still occur.

Jaap

edit flag offensive delete link more

Comments

@Jaap, no problem ;) Most of the times people can't share the documents (either because they are too personal or because they are confidential). I tried to reproduce your crash but didn't have any problems deleting or inserting lines under version 3.5.2. Maybe it's already fixed...

Pedro gravatar imagePedro ( 2012-04-08 10:46:09 +0200 )edit
1

Problem is fixed in 3.5.2. We used the wrong ScDBData in cell updates.

moggi gravatar imagemoggi ( 2012-04-10 17:34:05 +0200 )edit

Question Tools

Stats

Asked: 2012-04-07 13:46:58 +0200

Seen: 1,768 times

Last updated: Apr 14 '12