** 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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/262511 Title: Formula color-coding fails when multiple identical cell references Status in LibreOffice Productivity Suite: Incomplete Status in The OpenOffice.org Suite: Confirmed Status in “libreoffice” package in Ubuntu: Triaged Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org 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)) 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 . 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 . To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/262511/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
