Public bug reported:

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)

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug oneiric running-unity

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/902085

Title:
  Libreoffice Calc conditional formatting error

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

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to