Hey there,
I’m wondering if this is a bug or intended:
When you add rows in a spreadsheet and have for example a “sum” field under it (like adding another bill into a checking account or something), then the row is being inserted, but the sum field doesn’t update the area it is referred to.
For example:
A40 is : =SUM(M9:M38)
Then you add seven rows somewhere in between and would expect to become M9:M45. That doesn’t seem to happen and to me that seems like a bug.
thanks for your answers, cheers
That does happen (on my system which is LibreOffice 7.0.6.2 on openSUSE 15.2 using TDF packages):
Watch the red sum formula showing the formula in cell left (using function FORMULA()=
Now I do see it also! Huh, dont know, had to correct it before, but maybe just did something wrong. Thanks for your answer!