In Ubuntu 10.10, opened up fresh LibreOffice Calc spreadsheet, highlighted only A1 through A3, clicked Format -> Conditional Formatting... -> Condition 1 checkbox checked (was by default) -> Cell value is in dropdown box -> equal to in dropdown box -> in field typed A -> Cell Style dropdown box is Default (was Default by default) -> clicked New style... button -> in Cell Style window clicked Background tab -> clicked Green -> clicked OK button
*** notice Cell Style drop downbox box for Condition 1 changed itself from Default to Untitled1 -> Clicked Condition 2 checkbox -> Cell value is in dropdown box -> equal to in dropdown box -> capital B -> Cell Style dropdown Default (was Default by default) -> clicked New style... button -> in Cell Style window clicked Background tab -> clicked Yellow -> clicked OK button *** notice Cell Style drop downbox box for Condition 1 changed itself from Default to Untitled2 -> in Conditional Formatting window clicked OK button. Only Cells A1 through A3 were green, no columns in B changed to yellow. sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.0-1maverick1 Candidate: 1:3.3.0-1maverick1 Version table: *** 1:3.3.0-1maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status ** Changed in: openoffice.org (Ubuntu) Status: Incomplete => New ** Tags added: lo33 ** Summary changed: - Conditional Formatting does not work in OOo 3.2.1 (10.10) + Conditional Formatting does not work properly -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs