https://bugs.documentfoundation.org/show_bug.cgi?id=136537
Heiko Tietze <heiko.tie...@documentfoundation.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WONTFIX
--- Comment #7 from Heiko Tietze <heiko.tie...@documentfoundation.org> ---
The expected behavior is effective if you add a row within the range or when
Tools > Options > Calc > General > Input Settings "Expand references when new
columns/rows are inserted" is enabled, see [1].
The other workflow, moving a selection, is not supported for good reasons.
While the first changes the whole sheet with the purpose of adding data the
latter is just to change the visualization. You drag the formula result to a
more prominent place, for example. Imagine to move not just a few rows down but
some columns to the right - would be surprising if the calculation changes
completely.
And last but not least this is exactly how MS Excel behaves. Moving a section
never changes the formula while adding a row does. => WF
[1]
file:///usr/lib/libreoffice/help/en-US/text/shared/optionen/01060300.html?System=UNIX&DbPAR=CALC&HID=modules/scalc/ui/scgeneralpage/ScGeneralPage#bm_id3147211
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
