← Back to team overview

desktop-packages team mailing list archive

[Bug 631857] Re: Conditional Formatting does not work properly

 

Wolf Rogner, according to: 
http://help.libreoffice.org/Calc/Applying_Conditional_Formatting

It clearly states:

"To Define the Conditions

    Select the cells to which you want to apply a conditional style."

So, only selecting cells A1:A3, applying the desired Conditional Formatting, and expecting it to apply to columns A and B are invalid. The same rationale holds true for OpenOffice according to:
documentation.openoffice.org/HOW_TO/spreadsheet/calc3_EN.pdf
Feel free to report any future bugs you may find.

** Changed in: libreoffice (Ubuntu)
       Status: Confirmed => Invalid

** Changed in: openoffice.org (Ubuntu)
       Status: New => Invalid

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

Title:
  Conditional Formatting does not work properly

Status in LibreOffice Productivity Suite:
  Fix Released
Status in “libreoffice” package in Ubuntu:
  Invalid
Status in “openoffice.org” package in Ubuntu:
  Invalid

Bug description:
  Binary package hint: gvfs

  Open up fresh spreadsheet, highlight only A1 through A3, click Format
  -> Conditional Formatting... -> Condition 1 checkbox checked (was by
  default) -> Cell value in dropdown box -> equal to in dropdown box ->
  in field type A -> Cell Style dropdown box is Default (was Default by
  default) -> click New style... button -> in Cell Style window click
  Background tab -> click Green -> click OK button

  *** Notice Cell Style drop downbox box for Condition 1 changed itself
  from Default to Untitled1

  -> Click Condition 2 checkbox -> Cell value is in dropdown box ->
  equal to in dropdown box -> in field type B -> Cell Style dropdown box
  is Default (was Default by default) -> click New style... button -> in
  Cell Style window click Background tab -> click Yellow -> click OK
  button

  *** Notice Cell Style drop downbox box for Condition 1 changed itself
  from Default to Untitled2

  -> in Conditional Formatting window clicked OK button.

  Cells in column A & B are not green & yellow respectively.

  ProblemType: Bug
  DistroRelease: Ubuntu 10.04
  Package: gvfs 1.6.1-0ubuntu1build1
  ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5
  Uname: Linux 2.6.32-24-generic x86_64
  NonfreeKernelModules: nvidia
  Architecture: amd64
  Date: Mon Sep  6 20:46:51 2010
  InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release Candidate amd64 (20091020.3)
  ProcEnviron:
   LANGUAGE=en_GB:en
   LANG=en_GB.utf8
   SHELL=/bin/bash
  SourcePackage: gvfs
  Symptom: storage
  Title: Documents cannot be opened in desktop UI on storage device

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions