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.
** Attachment added: "lottoPermErr.ods" http://launchpadlibrarian.net/16381493/lottoPermErr.ods -- Open Office Spreadsheet Sheet Copy error https://bugs.launchpad.net/bugs/243271 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
