← Back to team overview

desktop-packages team mailing list archive

[Bug 235602] Re: [upstream] [hardy] Calc Conditional Formatting - Incorrect cell references after line or column insertions

 

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

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 2011-06-06T12:46:49+00:00 Christopher M. Penalver wrote:

Created attachment 47597
Conditional formatting example.ods

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

OOo bug may be found at:
http://openoffice.org/bugzilla/show_bug.cgi?id=4155

1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

2) 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

3) What is expected to happen with LibreOffice Calc via the Terminal:

cd ~/Desktop && wget
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods
&& localc -nologo 'Conditional formatting example.ods'

place the cursor in row 12 -> Insert -> Row and all the rows move down,
and the highlighting does not change.

4) What happens instead is B13 and D13 lose their highlighting.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/235602/comments/12

------------------------------------------------------------------------
On 2011-10-10T09:58:06+00:00 E-osc wrote:

I confirm behaviour witj LO 3.4.3 (release) and Windows O/S.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/235602/comments/14

------------------------------------------------------------------------
On 2011-10-10T16:04:08+00:00 Christopher M. Penalver wrote:

Dnk1287, please do not toggle the version. For more details please see
http://wiki.documentfoundation.org/BugReport_Details#Version

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/235602/comments/15

------------------------------------------------------------------------
On 2011-11-07T10:42:48+00:00 E-osc wrote:

Created attachment 53237
conditional formatting problem with delete row/column as well

A similar problem occurs with row/column removal as well; see attachment.
When you remove column A or column C, either the condition for E2 or E3 becomes incorrect.

(Windows with version 3.4.3 and Linux with version 3.5.0))

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/235602/comments/16


** Bug watch added: openoffice.org/bugzilla/ #4155
   http://openoffice.org/bugzilla/show_bug.cgi?id=4155

-- 
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/235602

Title:
  [upstream] [hardy] Calc Conditional Formatting - Incorrect cell
  references after line or column insertions

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-calc

  1) lsb_release -rd
  Description:	Ubuntu 11.04
  Release:	11.04

  2) 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

  3) What is expected to happen with LibreOffice Calc via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods
  && localc -nologo 'Conditional formatting example.ods'

  place the cursor in row 12 -> Insert -> Row and all the rows move
  down, and the highlighting does not change.

  4) What happens instead is B13 and D13 lose their highlighting.

  Original Reporter Comments: Ubuntu 8.04 LTS OpenOffice.org Calc
  Version: 1:2.4.0-3ubuntu6

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