Public bug reported: Binary package hint: openoffice.org
This is best explained by reference to an example. Attached is a spreadsheet with a series of formulas (a1:a9) and a series of data (b5:d7). The formulas refer to the data; aX = bY + cY + dY, where Y is X + 4; in other words, A1 is B5 + C5 + D5, etc. If you cut from C6 (a data cell, which A2 refers to) and paste into C8, the formula in A2 is altered to B6 + C8 + D6, so the value in C8 is counted twice (in A2 and in A4). This is clearly buggy - I've never known any other spreadsheet app to behave in this way. Cutting a data cell should NOT affect formula cells (except to recalculate the formulas, perhaps.) This is in Open Office 3.2.0, build 9483. Please fix! ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New -- 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