Wolf Rogner (war-rsb), if one wants to use Conditional Formatting to
change the background of cell A1 containing an uppercase A to green, and
cell A2 containing an uppercase B to yellow one may perform at the
Terminal:
localc -nologo
highlight cells A1 through A3 -> click Format -> Conditional
Formatting... -> Condition 1 checkbox checked -> Cell value in dropdown
box -> equal to in dropdown box -> in field type "A" (include the double
quotes) -> click New style... button -> in Cell Style window click
Background tab -> click Green -> click OK button -> Condition 2 checkbox
checked -> Cell value is in dropdown box -> equal to in dropdown box ->
in field type "B" (include the double quotes) -> click New style...
button -> in Cell Style window click Background tab -> click Yellow ->
click OK button -> in Conditional Formatting window clicked OK button
and notice A1 background is green, A2 is yellow, and A3 is not changed.
lsb_release -rd
Description: Ubuntu oneiric (development branch)
Release: 11.10
apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.4.2-2ubuntu3
Candidate: 1:3.4.2-2ubuntu3
Version table:
*** 1:3.4.2-2ubuntu3 0
500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
100 /var/lib/dpkg/status
--
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:
Fix Released
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 : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
