Background color rendered incorrectly with certain Conditional Format formulas involving Defined Names
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
libreoffice (Ubuntu) |
Expired
|
Undecided
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
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-
2. Insert-
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-
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
ProcVersionSign
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
Changed in openoffice.org (Ubuntu): | |
status: | New → Won't Fix |
[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.