https://bugs.documentfoundation.org/show_bug.cgi?id=113896
Buovjaga <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #2 from Buovjaga <[email protected]> ---
Currently the formula is updated, if you move a cell referenced in it. In your
steps you do not move A3, so nothing happens.
The current behaviour would conflict with your proposed: "This would extend the
formula to newly created A1 if the user clicks "Insert Row Above" in row 1"
This sort of mind-reading is difficult and changed behaviour might cause users
to be upset.
A working solution for these simple "numbers + sum formula" things is to have
one blank row above the sum row and to include it in the sum range. Now when
you insert rows from the last row with numbers, the formula range is updated.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
