[Bug 262511] Re: Formula color-coding fails when multiple identical cell references
** Tags added: i386 oneiric ** Summary changed: - Formula color-coding fails when multiple identical cell references + Formula color-coding inconsistent with multiple identical cell references ** Bug watch added: freedesktop.org Bugzilla #48719 https://bugs.freedesktop.org/show_bug.cgi?id=48719 ** Changed in: df-libreoffice Importance: Undecided => Unknown ** Changed in: df-libreoffice Status: Incomplete => Unknown ** Changed in: df-libreoffice Remote watch: None => freedesktop.org Bugzilla #48719 ** Summary changed: - Formula color-coding inconsistent with multiple identical cell references + [Upstream] Formula color-coding inconsistent with multiple identical cell references -- 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: [Upstream] Formula color-coding inconsistent with 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 262511] Re: Formula color-coding fails when multiple identical cell references
John Pye, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance. ** Changed in: df-libreoffice Status: New => Incomplete -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 262511] Re: Formula color-coding fails when multiple identical cell references
** 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 262511] Re: Formula color-coding fails when multiple identical cell references
This bug is still present in LibreOffice in Ubuntu 11.10 (LO 3.4.3). ** Attachment added: "highlighting.png" https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2570972/+files/highlighting.png ** Changed in: libreoffice (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/262511 Title: Formula color-coding fails when multiple identical cell references To manage notifications about this bug go to: https://bugs.launchpad.net/openoffice/+bug/262511/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 262511] Re: Formula color-coding fails when multiple identical cell references
** Summary changed: - [upstream] Formula color-coding fails when multiple identical cell references + Formula color-coding fails when multiple identical cell references -- 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/openoffice/+bug/262511/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 262511] Re: Formula color-coding fails when multiple identical cell references
** Changed in: openoffice Importance: Undecided => Unknown Bugwatch: None => OpenOffice.org Issue Tracker #26787 Status: New => Unknown ** Summary changed: - Formula color-coding fails when multiple identical cell references + [upstream] Formula color-coding fails when multiple identical cell references -- [upstream] Formula color-coding fails when multiple identical cell references https://bugs.launchpad.net/bugs/262511 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 262511] Re: Formula color-coding fails when multiple identical cell references
Verified on upstream's openoffice.org 3.0.0. ** Changed in: openoffice.org (Ubuntu) Importance: Undecided => Low Status: Incomplete => Triaged ** Also affects: openoffice Importance: Undecided Status: New -- Formula color-coding fails when multiple identical cell references https://bugs.launchpad.net/bugs/262511 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 262511] Re: Formula color-coding fails when multiple identical cell references
Please attach an example document exhibiting this problem. ** Changed in: openoffice.org (Ubuntu) Status: New => Incomplete -- Formula color-coding fails when multiple identical cell references https://bugs.launchpad.net/bugs/262511 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