[Upstream] Formula color-coding inconsistent with multiple identical cell references

[John Pye]

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 .

[Chris Cheney (ccheney)]

Please attach an example document exhibiting this problem.

[Chris Cheney (ccheney)]

Verified on upstream's openoffice.org 3.0.0.

[JackPotte (hubert-bossot)]

Same problem encountered with Ubuntu for 1 year (the creation of the ods file), consequently I've worked with Windows Vista without any problem.
However with Jaunty Jackalope I can't reproduce it : it seems to be now resolved.

[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 still present in LibreOffice in Ubuntu 11.10 (LO 3.4.3).

[penalvch (penalvch)]

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.

[penalvch (penalvch)]

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/262511

1) lsb_release -rd
Description: Ubuntu precise (development branch)
Release: 12.04

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.5.2-2ubuntu1
  Candidate: 1:3.5.2-2ubuntu1
  Version table:
 *** 1:3.5.2-2ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ precise/main i386 Packages
        100 /var/lib/dpkg/status

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 .

[Beluga (beluga)]

I don't get any color at all.

Win 7 64-bit Version: 4.4.0.0.alpha1+
Build ID: 56019dcb79475606952a954fe732a3109441ffec
TinderBox: Win-x86@39, Branch:master, Time: 2014-10-30_07:27:11

[penalvch (penalvch)]

Fixed in Xenial.