We will be migrating from Ask to Discourse on the first week of August, read the details here

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

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 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... ( 2012-04-07 15:33:38 +0200 )edit ## 4 Answers Sort by » oldest newest most voted 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

more

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)

( 2013-01-26 18:18:47 +0200 )edit

@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

more

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

( 2012-04-19 01:03:03 +0200 )edit

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

more

@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

more

@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...

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

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

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