Comment 8 for bug 243271

To reproduce the Copy error, in file lottoPermErr.ods, you must copy sheet, Results, say, to Results 2, then compare the functions that appear in the lotto and plus columns in both versions of the copied sheet. In the original version, Results, you will see functions: =countif(lotto.range;value) and =countif(plus.range;value) in the lotto and plus columns respectively. Whereas, in the copied version, Results 2, you will now see functions: =countif(plus.range;value) and =countif(countLotto.range;value) in the lotto and plus columns respectively. The sheet references have been corrupted in Results 2. If the sheet references are protected by being prefixed with a $ sign, sheets, Results and Results 2 are the same. I am not aware that sheet references need to be protected in this way. See the attached ods file.