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

Reply via email to