** Attachment added: "excel-screenshot.png" https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2608715/+files/excel-screenshot.png
** Description changed: Binary package hint: openoffice.org - In Calc in OpenOffice on Hardy, I have a problem when editing cells with - formulae like this: + 1) lsb_release -rd + Description: Ubuntu 11.10 + Release: 11.10 + + 2) apt-cache policy libreoffice-calc + libreoffice-calc: + Installed: 1:3.4.4-0ubuntu1 + Candidate: 1:3.4.4-0ubuntu1 + Version table: + *** 1:3.4.4-0ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages + 100 /var/lib/dpkg/status + 1:3.4.3-3ubuntu2 0 + 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages + + 3) What is expected to happen in LibreOffice Calc is in a blank document + if one places in D7: =IF(D13=0;1;EXP(-delta^D13)) - When I press 'F2' to see the color-coded form of this formula (with - cells color-coded to indicate where different values are coming from), - the first 'D13' in this formula comes up blue and the second 'D13' comes - up red, even though they are the same cell. Then, the actual cell D13 is - color-coded red as well, so there is no indication about what/where the - blue cell should be. + only the first D13 left to right is highlighted, while the second D13 is + either the same color or not highlighted at all as in Excel screenshot + https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2608715/+files + /excel-screenshot.png . - This is clearly a simple implementation error where repeated cell - references are not checked for. + 4) What happens instead is the first D13 is blue while the second is red + as shown in the screenshot + https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2570972/+files/highlighting.png + . ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Low ** Changed in: libreoffice (Ubuntu) Status: Confirmed => Triaged ** Also affects: df-libreoffice Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/262511 Title: Formula color-coding fails when multiple identical cell references To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/262511/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
