desktop-packages team mailing list archive

[Wolf Rogner <war@xxxxxx>]

I am sorry that my patience is very limited with this one.

I think the steps in my description pretty much tell you what to do.

Just try to conditionally format a cell to green background if it
contains a specific value: ZILCH

Try to format two cells to red and green according to two specific
values (say 1 and 0) but leave a third cell blank: ZILCH

Now turn to the Monopolists spreadsheet application and look how it
works (for my expected behaviour): YEP

I elaborated on this error once. It got fixed, fine. Now its here again.
What shall I take from this.

Christopher, I'd be greateful if you just tried it yourself and then ask
questions if you cannot reproduce.

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

Title:
  Libreoffice Calc conditional formatting error

Status in “libreoffice” package in Ubuntu:
  Incomplete

Bug description:
  Conditional formatting in LibreOffice does not work correctly.

  This error was corrected in OpenOffice and reappeared in LibreOffice.

  Test:

  Enter a cell value of 1 and a value of 2 in the next value
  Mark 3 cells (on including no value)
  Conditional format 1 to background green, 2 to background red and empty to background gray.

  Use equal to, use less than or greater than, it does not work.

  What works is that the cell gets coloured green if you say: not equal
  to: 1

  However, combining negatives does not work either.

  ProblemType: Bug
  DistroRelease: Ubuntu 11.10
  Package: libreoffice (not installed)
  ProcVersionSignature: Ubuntu 3.0.0-13.22-generic 3.0.6
  Uname: Linux 3.0.0-13-generic x86_64
  NonfreeKernelModules: wl nvidia
  ApportVersion: 1.23-0ubuntu4
  Architecture: amd64
  Date: Fri Dec  9 10:23:05 2011
  InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64+mac (20111012)
  ProcEnviron:
   PATH=(custom, no user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: No upgrade log present (probably fresh install)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/902085/+subscriptions