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
