Description: We have source data and an output formula that uses that data. We move the source data to another place by dragging the mouse. The addresses in the resulting formula are modified. We perform the CTRL+Z operation, reverting the changes made. If the resulting formula is in the same sheet as the source data, the operation is performed correctly. If the result formula is on a different worksheet, even though the source data returns to where it was, the addresses in the result formula are not restored. Performing the same operation with CTRL+X → CTRL+V can be undone without any problems (press CTRL+Z twice). Actual Results: Enter the case number A1 of sheet1. Enter the formula =sheet1.A1 in sheet2. Drag cell A1 in sheet1 with the mouse. The address in the formula has changed accordingly. Do CTRL+Z. Expected Results: The formula in cell A1 in sheet2 does not have the original address Reproducible: Always User Profile Reset: No Additional Info: Restore the address from before the change.
Confirmed. Already in 6.2.8, ok in 6.2.0; regression, requesting bibisect.
Bibisected repository win32-6.2. Couldn't find dennis.francis@collabora.com in the mailing list, unsure if dennisfrancis.in@gmail.com belongs to the dev. Regression introduced via: https://git.libreoffice.org/core/+/559dadd0d6eaa61dab7e0bc2a510b87b7109be22 Note that this commit was done to fix Bug 124326: https://bugs.documentfoundation.org/show_bug.cgi?id=124326 2f411ac7514462e199d9730116922069d7447cf8 is the first bad commit commit 2f411ac7514462e199d9730116922069d7447cf8 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Sat Apr 6 07:19:33 2019 -0700 source 559dadd0d6eaa61dab7e0bc2a510b87b7109be22 commit 559dadd0d6eaa61dab7e0bc2a510b87b7109be22 [log] author Dennis Francis <dennis.francis@collabora.com> Thu Apr 04 14:07:11 2019 +0530 committer Dennis Francis <dennis.francis@collabora.com> Sat Apr 06 16:05:30 2019 +0200 tree 5ca85a5ee3327170acdfe714dc5a4e3a0f88da3b parent e59e4c41e0fd9beaa03a60def58feefdef1e0bb6 [diff]