Created attachment 112975 [details]
Simple demonstration of bug per Description
When a copy and paste is done of a cell with a formula that contains a label, the label is treated as an absolute reference rather than relative reference.
Attached file, CopyPasteWithLabels.ods can be used to demonstrate the problem by the following steps.
1. Copy and paste cell c2 to cell c3. Trace precedents on cell c3 and see that the answer is wrong because in cell c3, the references 'label1' and 'label2' are to row 2 and they should be to row 3.
2. Rather than copying and pasting c2 to c3, type in exact contents of c2 into c3 and the c3 evaluation of the formula gives the correct answer, 43.5.
3. Click the "undo" button and the result in c3 doesn't change back to the incorrect answer, 39, but remains the same, 43.5.
LO 184.108.40.206 works properly and LO 220.127.116.11 exhibits the bug.
Hi @dwyoung, thanks for reporting.
Versión: 18.104.22.168.beta1 Build ID: f4ca7b35f580827ad2c69ea6d29f7c9b48ebbac7
Version: 22.214.171.124.0+ Build ID: 1fc1d0d7d38bb16832d0d78d78682ed2d5f8716f
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2015-01-08_03:10:08
Last working for me:
Version: 126.96.36.199 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
Only happens copying from top to down not from bottom to up.
Remains only while working with the file after copy.
Hard recalc doesn't help.
The issue disappears saving and reopening.
Both parts of this seem to have begun at the below commit - the changed calculation and the changed precedents
Author: Kohei Yoshida <firstname.lastname@example.org>
Date: Fri Aug 9 16:41:22 2013 -0400
If the formula cell is grouped, update reference only on the top cell.
Migrating Whiteboard tags to Keywords: (bibisected)
Adding Cc: to Kohei Yoshida
The fix for Bug 93894 seems to fix this issue as well.
Testing of Kohei's fix so we can back-port it much appreciated; thanks ! =)
*** This bug has been marked as a duplicate of bug 93894 ***