desktop-packages team mailing list archive

[Bryan Quigley <bryan.quigley@xxxxxxxxxxxxx>]

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.


** Changed in: libreoffice (Ubuntu)
       Status: New => Incomplete

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