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