Cell named 'rho' doesn't evaluate correctly

[John Pye]

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

[penalvch (penalvch)]

John Pye, this is unreproducible in LibreOffice Calc via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/129185/+attachment/2144086/+files/example.ods && localc -nologo example.ods

notice B5 evaluates to 1. Does this work for you?

lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[John Pye (jdpipe)]

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