Scenario: A1: 1 A2: 2 A3: 3 B1: SUM(A1:A3) Now move the data range (A1:A3) with the mouse to (A2:A4). When you do that, the formula SUM(A1:A3) is automatically adjusted to SUM(A2:A4). Now undo the move. The data is reverted but the formula still says SUM(A2:A4). This happens in master but not in 4.1 so this is a regression in 4.2
Confirmed with Version: 4.2.0.0.alpha0+ Build ID: b7e5ab6f65eb682bfa200459d745d3bc4056e42a TinderBox: Win-x86@42, Branch:master, Time: 2013-10-24_22:59:23 Formula is not updated/reverted after Undo.
Still reproducible: Win7x64Ult. Version: 4.3.0.0.alpha0+ Build ID: 09155190d817dd880cc96a106114618b46a5a7e5 TinderBox: Win-x86@39, Branch:master, Time: 2014-03-01_23:56:24
I didn't see this because the version tag "4.2.0alpha...." was not in my search term. :-(
In the mean time I also forgot about it. Doesn't seem so important if I was the only one that reported this :)
(In reply to comment #4) > In the mean time I also forgot about it. Doesn't seem so important if I was > the only one that reported this :) Well, that may be true. But this sort of reference update is expected to be working, so it's best to fix this before anybody else notices it. ;-)
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=980898058f1411d234c009caaae58b29eb3420c8 fdo#71491: Write test for this. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=88955714d345d8584e86ae34bf5f5d1f3f4af9f7 fdo#71491: Adjust reference during undo of drag-n-drop of cell range. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fixed.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b85f07986dc005ea0a74baa3d14ee0fd1ec99609&h=libreoffice-4-2 fdo#71491: Adjust reference during undo of drag-n-drop of cell range. It will be available in LibreOffice 4.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Nice.. works flawlessly now in master.
Verified in: Version: 4.2.4.0.0+ Build ID: e1823627f35e4419880769fdd05acddbd0a9c25c TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-18