Problem description: Conditionally formatting cells depending on their content does not work. Steps to reproduce: 1. enter 1 .. 4 in cells A1..A4 2. select A1..A3 3. conditionally format if cell contains 1 .. background green if cell contains 2 .. background yellow if cell contains 3 .. background red else no background color Current behavior: no cell gets any background Expected behavior: cells A1 - A3 should have background green, yellow, red. If cell A1 changed to 4, cell background should change to nothing and if A2 changed to 1 cell background should be green (and so on). Platform (if different from the browser): MacbookPro 6,2 with Ubuntu 12.04 (11.10) Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0 This was reported over launchpad ever since 3.0. It never got fixed. If it cannot be fixed, take the function out of the menu.
I can't confirm this behavior. Can you please attach a test document where this happens.
Created attachment 59878 [details] testing conditional formatting
Tested and find conditional formatting working ubuntu 11.110 + lo 3.5.2 File attached
Comment on attachment 59878 [details] testing conditional formatting Nice with numbers, try a b c instead. It still does not work
You have to insert "a", "b" and "c" (with capitals) in the conditional format window instead of plain a,b or c. This works for me.
Has not been confirmed, sample document missing, probably user error. @reporter: Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information (Sample Document) due to <http://wiki.documentfoundation.org/BugReport>