desktop-packages team mailing list archive

[Erack <235602@xxxxxxxxxxxxxxxxxx>]

This is not related to bug 42261 or bug 44383.

The problem originates from how conditional formats are implemented, one
conditional can be applied to multiple cells, when moved around they
behave like named ranges and relative references are not updated but
applied to the then current position instead.

There's no easy fix for this; splitting conditionals and creating
duplicates to be updated could be a possibility, somewhat similar to how
internal shared formulas are treated.

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