I've encountered the same problem. You can see it at work here. 1. See the attached spreadsheet: test.ods
Look at the Formula in cell L6. Note the cell references. It's function is probably irrelevant to the bug. It reads as follows: =IF(J6="B",L5+G6-H6-I6,IF(K6="B",L5-I6)) So far so good. The formula works. 2. Cut the data from column H, which is referred to in the formula we are concerned with in L6. Paste it into the adjacent cells in column I. Now the formula in L6 has mutated: =IF(J6="B",L5+G6-I6-I6,IF(K6="B",L5-I6)) The cell H6 in the formula has become I6. There are now two I6's in the formula. The formula is wrong. ** Attachment added: "File with example formula" https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/596139/+attachment/1666862/+files/test.ods -- Copy and paste of data cells in calc alters formulas referring to those cells https://bugs.launchpad.net/bugs/596139 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