[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
** Changed in: openoffice.org (Ubuntu) Status: Confirmed => Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/596139 Title: Copy and paste of data cells in calc alters formulas referring to those cells To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/596139/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
Reuben Firmin thank you for reporting this bug and making Ubuntu better. While this phenomenon is confirmed in Maverick, the reason for it is most likely a developer decision (I actually prefer the way it is). However, having the option of changing this association to what your expecting would be great. If this optionality is not available the next step is to link an upstream bug found performing a search via http://www.openoffice.org/issues/query.cgi or if not found reported via http://www.openoffice.org/issues/enter_bug.cgi?component=Spreadsheet lsb_release -rd Description:Ubuntu 10.10 Release:10.10 apt-cache policy openoffice.org-calc openoffice.org-calc: Installed: 1:3.2.1-7ubuntu1 Candidate: 1:3.2.1-7ubuntu1 Version table: *** 1:3.2.1-7ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status ** Changed in: openoffice.org (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/596139 Title: Copy and paste of data cells in calc alters formulas referring to those cells -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
Unexpired. This does not need apport. This is a straightforward and pervasive openoffice bug which can be reproduced with the attached example. ** Changed in: openoffice.org (Ubuntu) Status: Expired => New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/596139 Title: Copy and paste of data cells in calc alters formulas referring to those cells -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
[Expired for openoffice.org (Ubuntu) because there has been no activity for 60 days.] ** Changed in: openoffice.org (Ubuntu) Status: Incomplete => Expired -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/596139 Title: Copy and paste of data cells in calc alters formulas referring to those cells -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
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
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
apport information ** Tags added: apport-collected ** Description changed: 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! + --- + Architecture: i386 + DistroRelease: Ubuntu 10.04 + NonfreeKernelModules: nvidia + Package: openoffice.org-core 1:3.2.0-7ubuntu4.1 + PackageArchitecture: i386 + ProcEnviron: + PATH=(custom, user) + LANG=en_US.utf8 + SHELL=/bin/bash + ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2 + Tags: lucid + Uname: Linux 2.6.32-22-generic i686 + UserGroups: adm admin cdrom dialout lpadmin plugdev pulse pulse-access sambashare vboxusers ** Attachment added: "Dependencies.txt" http://launchpadlibrarian.net/50679289/Dependencies.txt -- 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
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
[This is an automatic notification.] Thank you for taking the time to report this bug and helping to make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal: apport-collect -p openoffice.org-core 596139 This will help us to find and resolve the problem. Bear in mind that you may need to install the python-launchpadlib package from the universe repository. Additionally, when prompted to give apport-collect permissions for Launchpad you will need to give it at least the ability to "Change Non-Private" data as it will be adding information to your bug report. Thanks in advance! When reporting bugs in the future please use apport, either via the appropriate application's "Help -> Report a Problem" menu or using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs. ubuntu-bug openoffice.org-core Please do not set bugs back to 'New' after adding this information. ** Changed in: openoffice.org (Ubuntu) Status: New => Incomplete -- 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
[Bug 596139] Re: Copy and paste of data cells in calc alters formulas referring to those cells
** Attachment added: "example" http://launchpadlibrarian.net/50567935/example_ss.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
