Conditional Formatting does not work properly

[Wolf Rogner]

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

[penalvch (penalvch)]

Wolf Rogner thank you for taking the time to report this bug and helping to make Ubuntu better. Please answer these questions:

* Is this reproducible?
* If so, what specific steps should we take to recreate this bug?
* Could you attach an example OOo file that demonstrates this problem?

This will help us to find and resolve the problem.

[Wolf Rogner (war-rsb)]

1. Yes it is reproducable (I would not file a bug otherwise)
2. Steps to reproduce:
a create a fresh spread sheet
b mark A1:A3
c select Format/Conditional Formatting ...
d Condition 1 (tagged): Cell value equal to "A" (enter A)
e create new style under Cell Style, make background green
f tag Condition 2
g Enter B in Cell value field (Cell value equal to "B")
h create new Cell Style, background to yellow
You can give the new styles different names.
You can proceed with a third condition

All fields were empty but they are marked green now
So: Cell A1 = empty <> "A" and its background is green

Enter A in A1
Cell A1 = "A" and its background is white (should be green)

Enter B in A2
Cell A2 = "B" and its background is white (should be yellow)

Enter C in A3
Cell A3 = "C" and its background is white (correkt)

All above results could be expected according to the online help

Variations:
Create conditional formatting for individual cells: same error
Create named styles: same error
Attack predefined styles : same error

Can I attach an example?
Unfortunately no. I manually formatted columns to get my results.
One can simple reproduce this by following above procedures.

Hope this helps.

[penalvch (penalvch)]

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

[penalvch (penalvch)]

Wolf Rogner, according to:
http://help.libreoffice.org/Calc/Applying_Conditional_Formatting

It clearly states:

"To Define the Conditions

    Select the cells to which you want to apply a conditional style."

So, only selecting cells A1:A3, applying the desired Conditional Formatting, and expecting it to apply to columns A and B are invalid. The same rationale holds true for OpenOffice according to:
documentation.openoffice.org/HOW_TO/spreadsheet/calc3_EN.pdf
Feel free to report any future bugs you may find.

[penalvch (penalvch)]

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

[Wolf Rogner (war-rsb)]

In Natty it does not work.

Simpy, there is no conditional formatting.

[penalvch (penalvch)]

Wolf Rogner, the same solution in comment #6 also applies to Natty.

 lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

 apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.3-1ubuntu2
  Candidate: 1:3.3.3-1ubuntu2
  Version table:
 *** 1:3.3.3-1ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

[Wolf Rogner (war-rsb)]

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