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. -- 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
