[Libreoffice-bugs] [Bug 113896] EDITING: Formula should be extended to a newly inserted row/ column

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113896

Buovjaga <todventtu at suomi24.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |todventtu at suomi24.fi

--- Comment #2 from Buovjaga <todventtu at suomi24.fi> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171118/73cf8f00/attachment-0001.html>