Background color rendered incorrectly with certain Conditional Format formulas involving Defined Names

[jimav]

Binary package hint: openoffice.org

Background color is rendered incorrectly in some or all pixels of cells when their color changes as a result of a Conditional Format which is triggered by a data change, AND all of the following are true:

  - The cell with a conditional format is to the left of the cell with the data referenced in the C.F. formula
  - The cell with the data is not formatted to display horizontally centered.
  - The conditional format uses a formula which refers to a Defined Name
  - The Defined Name is an absolute column range (e.g. $C$2:$C$6) without a sheet name.

Please see attached screen shot showing the rendering errors (they go away when the screen is refreshed).

Also, please open the attached demo spreadsheet, which shows the problem.

STEPS TO REPRODUCE:

1. Create a style with a different background color (create a sample sell of another color, select it, then Format->Styles&Formatting, click "new from selection" icon)

2. Insert->Names->Define and define name "Data" to be $Sheet1.$C$2:$C$6

3. Select cells A2:B6, Format->Conditional Formatting,
   set the drop-down to "Formula Is" and set formula to "Data <> 0" (without the quotes),
   and specify the name of your new style.

4. Apply an identical Conditional Format to cells D2:D6 (or use the Format Paintbrush to copy the format from column A or B)

4. Enter 1 or 0 in C2 through C6. Be sure column C is not formatted in any way (Format->DefaultFormat to be sure)

5. Toggle cells in col C between 1 and 0
Result: The color of cells in columna A,B, and D change, but col A is sometimes wrong and col B is sometimes wrong in some pixels (see attached screen shot).

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org-calc 1:3.2.1-7ubuntu1.1
ProcVersionSignature: Ubuntu 2.6.35-25.44-generic 2.6.35.10
Uname: Linux 2.6.35-25-generic x86_64
Architecture: amd64
Date: Sat Mar 5 15:20:18 2011
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release Candidate amd64 (20100928)
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.utf8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[jimav (james-avera)]

In Libreoffice Calc 3.4.3 the symptoms are somewhat different (using BugDemo2_Corrected.ods attached in comment #4).

Initially, conditional formats are not triggered in any of the cells at all. However, if you select an entire unused column
and define a Name for it, then newly-created conditional formats can successfully refer to that name to access the value in that column (in the row of the cell with the conditional format).

It still seems to not work if the defined name refers only to a subset of rows, not all possible rows. See the demo file.

[Bryan Quigley (bryanquigley)]

Thank you for reporting this bug to Ubuntu. This Ubuntu release has reached EOL for Desktops.
See this document for currently supported Ubuntu releases: https://wiki.ubuntu.com/Releases

Please upgrade to the latest version (at least Ubuntu 14.04) and re-test. If the bug is still reproducible, please note that and set the status back to New.

Do feel free to report any other bugs you may find.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]