https://bugs.freedesktop.org/show_bug.cgi?id=69181
--- Comment #2 from ebricca <ebri...@gmail.com> --- (In reply to comment #1) > Hi ebricca, thanks for reporting. > > Maybe the problem is that you not are using absolute references, using > relative references as you are doing, the formulas in the new sheet are > modified for a non existent sheet. > Use; > =$Sheet2.A1 > and do the copy, if you want retain the reference to Sheet2. > > If you are not used about absolute/relative references, look in the help > index for "absolute addresses in spreadsheets" or in the LibreOffice > documentation about calc chapter 7 page 13, > https://wiki.documentfoundation.org/Documentation/ > Publications#LibreOffice_Calc_Guide thanks, you are right "absolute reference" resolves the primary issue the erratic behavior: renames the "reference target sheet" to the one one of the "copy sheet" =Sheet2.A1 or =#REF!.A1 where i can't see a rule remains -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs