desktop-packages team mailing list archive

["Christopher M. Penalver" <christopher.penalver@xxxxxxx>]

** Attachment added: "excel-screenshot.png"
   https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2608715/+files/excel-screenshot.png

** Description changed:

  Binary package hint: openoffice.org
  
- In Calc in OpenOffice on Hardy, I have a problem when editing cells with
- formulae like this:
+ 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))
  
- When I press 'F2' to see the color-coded form of this formula (with
- cells color-coded to indicate where different values are coming from),
- the first 'D13' in this formula comes up blue and the second 'D13' comes
- up red, even though they are the same cell. Then, the actual cell D13 is
- color-coded red as well, so there is no indication about what/where the
- blue cell should be.
+ 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 .
  
- This is clearly a simple implementation error where repeated cell
- references are not checked for.
+ 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
+ .

** Changed in: libreoffice (Ubuntu)
   Importance: Undecided => Low

** Changed in: libreoffice (Ubuntu)
       Status: Confirmed => Triaged

** Also affects: df-libreoffice
   Importance: Undecided
       Status: New

-- 
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:
  Formula color-coding fails when multiple identical cell references

Status in LibreOffice Productivity Suite:
  Incomplete
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