← Back to team overview

desktop-packages team mailing list archive

[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 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