desktop-packages team mailing list archive

["Christopher M. Penalver" <christopher.penalver@xxxxxxx>]

** 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 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:
  New
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