https://bugs.freedesktop.org/show_bug.cgi?id=81330
--- Comment #4 from Albrecht Müller <[email protected]> --- Comment on attachment 102780 --> https://bugs.freedesktop.org/attachment.cgi?id=102780 Example file to show the effect. The attachment should help to confirm bug in the original bug report and shows that the problem of not following references occurs also if names are involved. How to reproduce: Copy the cells A3:B3 of Sheet2 and of Sheet3 somewhere into Sheet4. Current behaviour: The cells in Sheet 4 display, assuming the cells in Sheet2 have been copied first: Value in Sheet2 2 Value in Sheet3 2 Expected behaviour: The cells in Sheet 4 display: Value in Sheet2 2 Value in Sheet3 3 The problem is caused by the fact that cells B3 in Sheet2 and Sheet3 both contain “=value”. The name “value” is local to each sheet and refers to cell B2 in the same sheet. The first copy creates a new name “value” local to Sheet4, the second copy does not recognize the name clash. Thus the content of the second copy refers to the wrong cell. During creation of this example I found two other errors: a) I first created the content “=value” in cell B3 of Sheet2 and created the name later. Cell B3 did not update, i.e. the error message remained until I re-entered the content of cell B3. b) Undo does not work properly: When I copied the cells to Sheet4, a name “value” restricted to Sheet4 was created. I used Undo to cancel the effect of the copy, but this name remained. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
