Comment 12 for bug 243271

To reproduce:

http://launchpadlibrarian.net/16381493/lottoPermErr.ods

Open lottoPermErr.ods in Calc (the version that is 39.7 KiB. se attachment above)
Save the file locally (must do this in order to copy sheets)
Select the sheet "Results" (leftclick the tab at the bottom)
Rightclick the "Results" tab and select "Move/Copy Sheet..."
Change "Insert before" to "-move to end position-" and enable checkbox "Copy". Click OK.
A new shet tab was created named "Results 3"
Compare the formulas in cells C2 in the sheets "Results" and "Results 3".

The content in cell C2 in sheet "Results" is: =COUNTIF(lotto.$E$8:$K$8;B2)
But cell C2 in the sheet "Result 3" contains: =COUNTIF(countLotto.$E$8:$K$8;B2)
Expected behavior is that the formulas are the same, but they are not.