← Back to team overview

desktop-packages team mailing list archive

[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 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 The OpenOffice.org Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  Confirmed
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org

  In Calc in OpenOffice on Hardy, I have a problem when editing cells
  with formulae like this:

  =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.

  This is clearly a simple implementation error where repeated cell
  references are not checked for.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openoffice/+bug/262511/+subscriptions