[Libreoffice-bugs] [Bug 136537] Cell formulas get corrupted with Drag & Drop

[bugzilla-daemon at bugs.documentfoundation.org]

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

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #7 from Heiko Tietze <heiko.tietze at 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 the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201002/a109842c/attachment.htm>