https://bugs.freedesktop.org/show_bug.cgi?id=81435
--- Comment #10 from Albrecht Müller <[email protected]> --- (In reply to Charles Brescia from comment #9) Hello Charles, I think the bug you reported is related to this one, but I could not reproduce it with LibreOffice Version: 4.3.2.2, Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d under Windows 7. Maybe it is fixed already. My original problem given in attachment 102929 is still there, however. Your report inspired me to try my example using CTRL+X and CTRL+V instead of CTRL+C and CTRL+V, i.e. moving the content instead of copying it. This produced the following results: a) Moving Content using CTRL+X and CTRL+V: References remain intact. b) Copy using CTRL+X and CTRL+V at the original place (to restore the content) and then CTRL+V at the target location: References get damaged in the same way as if the equivalent CTRL+C and CTRL+V had been used. c) Copy using a move CTRL+X and CTRL+V at the target location first and then an additional CTRL+V at original place to restore the content: References remain intact. There is an additional strange effect: Move the cells in Sheet2_2.A3:C7 to Sheet2_1.A1:C14 using CTRL+X and CTRL+V. Then cell C14 shows a zero value. Applying CTRL+Shift+F9 does not change this. Use CTRL+C and CTRL+V to copy the contents of this cell into some other empty place in the same sheet. The copy shows the correct value 21. You produced two cells containing exactly the same content but displaying different values. Now copy cells A1:C14 to their original place again using CTRL+C and CTRL+V. This time the sum filed show again its correct value. Change a value in one of the fields C3, C4 or C5. The sum value in C7 will not change. You can see the reason by pressing CTRL+F3: The variables point to the cells in Sheet2_1 instead of Sheet2_2. If you switch back to Sheet2_1, it is interesting to see that cell C14 now shows the value that should appear in the sum cell of Sheet2_2. You still have two cells containing exactly the same content but showing different values. Edit cell C14, just add a blank at the end of the content line and press enter. Now this cell and its copy show the same value. Albrecht -- 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
