desktop-packages team mailing list archive

[jimav <729922@xxxxxxxxxxxxxxxxxx>]

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.

** Also affects: libreoffice (Ubuntu)
   Importance: Undecided
       Status: New

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/729922

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

Status in “libreoffice” package in Ubuntu:
  New
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

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->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

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/729922/+subscriptions