Calc crashes when inserting/deleting row(s)

[Jaap]

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

[Pedro1]

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

[Jaap]

@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

[mmohrhard]

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

[mariosv]

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

[Jaap]

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

[qubit1]

Per @mmohrhard’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)

[Jaap]

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

@Pedro1: 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

[Pedro1]

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

[mmohrhard]

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