Sorry for my stubornness. I did not try " (double quotes). Using single quotes changes the content of the fields (A becomes a sometimes).
It works like described, thanks -- 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/631857 Title: Conditional Formatting does not work properly Status in LibreOffice Productivity Suite: Invalid Status in “libreoffice” package in Ubuntu: Invalid Status in “openoffice.org” package in Ubuntu: Invalid Bug description: Binary package hint: gvfs Open up fresh spreadsheet, highlight only A1 through A3, click Format -> Conditional Formatting... -> Condition 1 checkbox checked (was by default) -> Cell value in dropdown box -> equal to in dropdown box -> in field type A -> Cell Style dropdown box is Default (was Default by default) -> click New style... button -> in Cell Style window click Background tab -> click Green -> click OK button *** Notice Cell Style drop downbox box for Condition 1 changed itself from Default to Untitled1 -> Click Condition 2 checkbox -> Cell value is in dropdown box -> equal to in dropdown box -> in field type B -> Cell Style dropdown box is Default (was Default by default) -> click New style... button -> in Cell Style window click Background tab -> click Yellow -> click OK button *** Notice Cell Style drop downbox box for Condition 1 changed itself from Default to Untitled2 -> in Conditional Formatting window clicked OK button. Cells in column A & B are not green & yellow respectively. ProblemType: Bug DistroRelease: Ubuntu 10.04 Package: gvfs 1.6.1-0ubuntu1build1 ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5 Uname: Linux 2.6.32-24-generic x86_64 NonfreeKernelModules: nvidia Architecture: amd64 Date: Mon Sep 6 20:46:51 2010 InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release Candidate amd64 (20091020.3) ProcEnviron: LANGUAGE=en_GB:en LANG=en_GB.utf8 SHELL=/bin/bash SourcePackage: gvfs Symptom: storage Title: Documents cannot be opened in desktop UI on storage device To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
