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@lists.freedesktop.org Reporter: e...@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.