Created attachment 118594 [details] Example Copying a sheet before itself does not keep the formulas' references as it does when the copy is to after itself. In the attached examples just copy "Qua" to after and before itself. To after the copy is correct while to before is not. LO calc 5.0.1.2.
Hi @Paulo, thanks for reporting. I think not such issue, the formulas in QUA are relatives to Rec (not $Rec.), copying before they change accordantly to S3, copying before doesn't change because Rec it's the last sheet and only could be changed to an error reference.
(In reply to m.a.riosv from comment #1) > Hi @Paulo, thanks for reporting. > > I think not such issue, the formulas in QUA are relatives to Rec (not > $Rec.), copying before they change accordantly to S3, copying before doesn't > change because Rec it's the last sheet and only could be changed to an error > reference. No. The usual procedure (excel, gnumeric, google doc and other venerable spreadsheet programs) is to maintain all references (including those of the charts) the same when copying a sheet. Furthermore, I see no use in changing references except creating all sorts of inconsistencies as that of "last sheet". References are to be kept. Regards. Paulo
Just a clarification: When I said "all references" I meant "all external references". Internal references should be changed to point to the new sheet. The point is: The new sheet should mimic exactly the original sheet behaviour.
When yes, when no? If the issue is with external link then this seems a duplicate. If you are not agree reopen it. *** This bug has been marked as a duplicate of bug 85538 ***