← Back to team overview

desktop-packages team mailing list archive

[Bug 129185] Re: Cell named 'rho' doesn't evaluate correctly

 

This bug is not present in LibreOffice on Ubuntu 11.10, so I guess the
OOo fix was migrated before the fork...

** Changed in: libreoffice (Ubuntu)
       Status: Incomplete => Invalid

-- 
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/129185

Title:
  Cell named 'rho' doesn't evaluate correctly

Status in The OpenOffice.org Suite:
  Fix Released
Status in “libreoffice” package in Ubuntu:
  Invalid
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org

  Create a new spreadsheet.
  In A1, enter 'rho'.
  In B1, enter 1
  Select A1 and B1 then select Insert --> Create names --> Left column --> OK.
  Move down to B5 and enter (no quotes): '=rho'

  Cell B5 evaluates to 0, not 1 as it should.

  I would regard this as really quite a serious bug, given how automatic
  the use of names in spreadsheets is for some users.

  Bug is possibly related to the 'R1C1' method of referring to cells.

  Am reporting here first, as in the past I have reported bugs in OOo
  that have turned out to be distro-specific.

  Cheers
  JP

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