← Back to team overview

desktop-packages team mailing list archive

[Bug 902085] [NEW] Libreoffice Calc conditional formatting error

 

Public bug reported:

Conditional formatting in LibreOffice does not work correctly.

This error was corrected in OpenOffice and reappeared in LibreOffice.

Test:

Enter a cell value of 1 and a value of 2 in the next value
Mark 3 cells (on including no value)
Conditional format 1 to background green, 2 to background red and empty to background gray.

Use equal to, use less than or greater than, it does not work.

What works is that the cell gets coloured green if you say: not equal
to: 1

However, combining negatives does not work either.

ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: libreoffice (not installed)
ProcVersionSignature: Ubuntu 3.0.0-13.22-generic 3.0.6
Uname: Linux 3.0.0-13-generic x86_64
NonfreeKernelModules: wl nvidia
ApportVersion: 1.23-0ubuntu4
Architecture: amd64
Date: Fri Dec  9 10:23:05 2011
InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64+mac (20111012)
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug oneiric running-unity

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

Title:
  Libreoffice Calc conditional formatting error

Status in “libreoffice” package in Ubuntu:
  New

Bug description:
  Conditional formatting in LibreOffice does not work correctly.

  This error was corrected in OpenOffice and reappeared in LibreOffice.

  Test:

  Enter a cell value of 1 and a value of 2 in the next value
  Mark 3 cells (on including no value)
  Conditional format 1 to background green, 2 to background red and empty to background gray.

  Use equal to, use less than or greater than, it does not work.

  What works is that the cell gets coloured green if you say: not equal
  to: 1

  However, combining negatives does not work either.

  ProblemType: Bug
  DistroRelease: Ubuntu 11.10
  Package: libreoffice (not installed)
  ProcVersionSignature: Ubuntu 3.0.0-13.22-generic 3.0.6
  Uname: Linux 3.0.0-13-generic x86_64
  NonfreeKernelModules: wl nvidia
  ApportVersion: 1.23-0ubuntu4
  Architecture: amd64
  Date: Fri Dec  9 10:23:05 2011
  InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64+mac (20111012)
  ProcEnviron:
   PATH=(custom, no user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: No upgrade log present (probably fresh install)

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


Follow ups

References