← Back to team overview

desktop-packages team mailing list archive

[Bug 262511] Re: [Upstream] Formula color-coding inconsistent with multiple identical cell references

 

Launchpad has imported 2 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=48719.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2012-04-14T19:39:24+00:00 Christopher M. Penalver 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
.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/comments/8

------------------------------------------------------------------------
On 2014-10-31T10:08:19+00:00 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

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/comments/9


** Changed in: df-libreoffice
       Status: Unknown => Confirmed

** Changed in: df-libreoffice
   Importance: Unknown => Low

-- 
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:
  [Upstream] Formula color-coding inconsistent with multiple identical
  cell references

Status in LibreOffice Productivity Suite:
  Confirmed
Status in The OpenOffice.org Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  Triaged
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

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
  .

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/262511/+subscriptions