OpenOffice

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

Bug #262511 reported by John Pye
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LibreOffice
Confirmed
Low
OpenOffice
Confirmed
Unknown
libreoffice (Ubuntu)
Fix Released
Low
Unassigned
openoffice.org (Ubuntu)
Won't Fix
Low
Unassigned

Bug Description

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 .

See original description
Revision history for this message
Chris Cheney (ccheney) wrote :

Please attach an example document exhibiting this problem.

Changed in openoffice.org:
status: New → Incomplete
Revision history for this message
Chris Cheney (ccheney) wrote :

Verified on upstream's openoffice.org 3.0.0.

Changed in openoffice.org:
importance: Undecided → Low
status: Incomplete → Triaged
GercoKees (gercokees)
Changed in openoffice:
importance: Undecided → Unknown
status: New → Unknown
Bug Watch Updater (bug-watch-updater)
Changed in openoffice:
status: Unknown → Confirmed
Revision history for this message
JackPotte (hubert-bossot) wrote : Re: [upstream] Formula color-coding fails when multiple identical cell references

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)
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix
Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote : migrating packaging from OpenOffice.org to Libreoffice

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

penalvch (penalvch)
summary: - [upstream] Formula color-coding fails when multiple identical cell
- references
+ Formula color-coding fails when multiple identical cell references
Revision history for this message
John Pye (jdpipe) wrote : 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).

Changed in libreoffice (Ubuntu):
status: New → Confirmed
Revision history for this message
penalvch (penalvch) wrote :
description: updated
Changed in libreoffice (Ubuntu):
importance: Undecided → Low
status: Confirmed → Triaged
Revision history for this message
penalvch (penalvch) wrote :

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.

Changed in df-libreoffice:
status: New → Incomplete
Revision history for this message
In , penalvch (penalvch) wrote :

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 .

penalvch (penalvch)
tags: added: i386 oneiric
summary: - Formula color-coding fails when multiple identical cell references
+ Formula color-coding inconsistent with multiple identical cell
+ references
penalvch (penalvch)
Changed in df-libreoffice:
importance: Undecided → Unknown
status: Incomplete → Unknown
summary: - Formula color-coding inconsistent with multiple identical cell
- references
+ [Upstream] Formula color-coding inconsistent with multiple identical
+ cell references
Revision history for this message
In , Beluga (beluga) wrote :

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

Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
importance: Unknown → Low
status: Unknown → Confirmed
Revision history for this message
penalvch (penalvch) wrote :

Fixed in Xenial.

Changed in libreoffice (Ubuntu):
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.