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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
