[Libreoffice-bugs] [Bug 143962] New: EDITING Address error when move (drag and drop) a range

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143962
           Summary: EDITING Address error when move (drag and drop) a
                    range
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: edil at helpidea.net

I use a simple range where the boundary first row is the 'Head" and boundary
end row is the "Foot".
In the Foot some cells refers to Head, other sum the column range.
Es. range A5:B10, put formulas in A10  = A5 and in B10  = SUM(B5:B9).
If I select A5:B5 (the Head) and drag and drop of two rows up, I find the
formulas:
in A10  = A3 (new position) and in B10  = SUM(B5:B9).(same of old positions).
The link has follow the movement for single cell, but for the range with the
same start position no.
In excel the range change and follow the movement.

For me this is a bug because we have two behavior for the same action, and this
easy carry a mistake.
Thank you in advance

-- 
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/20210819/9e94ea38/attachment.htm>