Conditional Formats sometimes corrupt rendering

[jimav]

Binary package hint: openoffice.org

Names defined for columns using Insert->Names->Define do not work, or are not reliable, when used in Conditional Formatting formulas. There are several problems:

1. A Conditional Format for a cell in a column which is mentioned in the condition formula via a column name does not work.

2. Column names defined without specifying a specific Sheet cause background-color changes to be only partially rendered in some cells (no, this is not another fglrx problem! It occurs with the free driver).

3. Column names defined WITH a specific Sheet can result in Conditional Formats to completely stop working after save & reload.

4. The above bugs go away depending on the formatting of the cells containing the value(s) accessed via column names in Conditional Formats; if the cell(s) have default formatting, the bugs are there, but changing to e.g. Centered makes the bugs vanish. To clarify, it is the format of the DATA SOURCE cell(s) referenced in the formulas in the Conditional Formats which affects whether rendering artifacts occur!

Please see the attached demo spreadsheet.

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4
ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-22-generic x86_64
Architecture: amd64
Date: Tue May 25 15:18:19 2010
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100429)
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[jimav (james-avera)]

Sorry, the first Screenshot.png was the wrong file. Here is the one showing bad rendering in cell A3

[penalvch (penalvch)]

jimav, thank you for reporting this bug and helping make Ubuntu better. Does LibreOffice Calc work for you?

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

[jimav (james-avera)]

Yes, bugs are still there (LibreOffice 3.3.1). Download the demo in comment#1, chmod+w, and open it to see.

[jimav (james-avera)]

Christopher, would you please post how to undo the effect of your instructions in #4, i.e., to revert back to openoffice.org?

After installing Libre, some dependencies needed by oo are now missing and "won't be installed" for reasons I don't understand. I prefer to wait until installing Natty to use Libre for production. Thanks.

$ cat /etc/apt/sources.list.d/libreoffice-ppa-maverick.list
# deb http://ppa.launchpad.net/libreoffice/ppa/ubuntu maverick main
# deb-src http://ppa.launchpad.net/libreoffice/ppa/ubuntu maverick main

$ sudo apt-get update; sudo apt-get --fix-broken install; sudo apt-get upgrade; sudo apt-get install openoffice.org
...
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 openoffice.org : Depends: openoffice.org-core (= 1:3.2.1-7ubuntu1.1) but it is not going to be installed
                  Depends: openoffice.org-writer but it is not going to be installed
                  Depends: openoffice.org-calc but it is not going to be installed
                  Depends: openoffice.org-impress but it is not going to be installed
                  Depends: openoffice.org-draw but it is not going to be installed
                  Depends: openoffice.org-math but it is not going to be installed
                  Depends: openoffice.org-base but it is not going to be installed
                  Depends: openoffice.org-report-builder-bin but it is not going to be installed
                  Depends: openoffice.org-officebean but it is not going to be installed
                  Depends: openoffice.org-filter-mobiledev but it is not going to be installed
                  Depends: openoffice.org-java-common (>= 1:3.2.1~) but it is not going to be installed
                  Recommends: openoffice.org-filter-binfilter but it is not going to be installed
E: Broken packages

[penalvch (penalvch)]

jimav, this bug is being closed for the following reasons:

A) Not respecting the one issue per bug policy. You mentioned 5 different issues, 4 in the description, 1 in comment # 6 (which is a support question that should be redirected to the libreoffice "Ask a question" https://answers.launchpad.net/df-libreoffice/+addquestion).

B) Each of the 4 issues brought up in the description are too general and unreproducible without step-by-step instructions:

> 1. A Conditional Format for a cell in a column which is mentioned in the condition formula via a column name does not work.

> 2. Column names defined without specifying a specific Sheet cause background-color changes to be only partially rendered in some cells (no, this is not another fglrx problem! It occurs with the free driver).

> 3. Column names defined WITH a specific Sheet can result in Conditional Formats to completely stop working after save & reload.

> 4. The above bugs go away depending on the formatting of the cells containing the value(s) accessed via column names in Conditional Formats; if the cell(s) have default formatting, the bugs are there, but changing to e.g. Centered makes the bugs vanish. To clarify, it is the format of the DATA SOURCE cell(s) referenced in the formulas in the Conditional Formats which affects whether rendering artifacts occur!

Thank you for your understanding in this matter and please feel free to re-file with step-by-step instructions for each problem in their own separate bug.