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 -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
