Created attachment 93720 [details]
This is an example of the descriped bug.
I have experienced in older OpenOffice calc documents sums are not recalculated when open the document or changing it.
As an example look at the attached document. Open it, go to the first table and fill into the grey cells (or in the first twelve cells) a value (e.g. "4") and go to the second table. There look at cell D6, where you now should find a sum bigger than zero, but it is zero.
Note that all this happens inspite of an activ option "Automatically calculate" and that the "Recalculate" command.
Operating System: All
Version: 184.108.40.206 release
Sorry, I was too fast. I wanted to add that the "Recalculate" command doesn't work in the descriped case.
I think it's a duplicate of bug 74014. Your example document is an .ots by the way, it's strange. Sophie
*** This bug has been marked as a duplicate of bug 74014 ***