Public bug reported:

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

** Affects: openoffice.org (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug lucid

-- 
Conditional Formats sometimes corrupt rendering
https://bugs.launchpad.net/bugs/585623
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to