desktop-packages team mailing list archive

[Björn Michaelsen <bjoern.michaelsen@xxxxxxxxxxxxx>]

** Changed in: openoffice.org (Ubuntu)
       Status: New => Won't Fix

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

Title:
  [Upstream] Calc DCOUNT function does not throw error in malformed
  expression =DCOUNT(A4:E13,0,A16:E17)

Status in LibreOffice Productivity Suite:
  Confirmed
Status in “gnumeric” package in Ubuntu:
  Invalid
Status in “libreoffice” package in Ubuntu:
  Triaged
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  Binary package hint: openoffice.org

  1_ lsb_release -rd
  Description:	Ubuntu 11.04
  Release:	11.04

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.2-1ubuntu5
    Candidate: 1:3.3.2-1ubuntu5
    Version table:
   *** 1:3.3.2-1ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 Packages
          100 /var/lib/dpkg/status
       1:3.3.2-1ubuntu4 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

  LibreOffice 3.4.0 
  DEV300m103 (Build:5)

  3) What is expected to happen in LibreOffice Calc via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/+attachment/1743794/+files/OO_DCOUNT_problem_2.ods
  && localc -nologo OO_DCOUNT_problem_2.ods

  is Sheet 1, cell B19's formula:

  =DCOUNT(A4:E13,0,A16:E17)

  throws an error as it is a malformed expression pointing to a non-
  existent column 0.

  4) What happens instead is it erroneously yields 5. Occurs in both
  Ubuntu LO & 3.4.0 Beta.

  WORKAROUND: Use Gnumeric as it throws an error.

  apt-cache policy gnumeric
  gnumeric:
    Installed: 1.10.13-1ubuntu1
    Candidate: 1.10.13-1ubuntu1
    Version table:
   *** 1.10.13-1ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
          100 /var/lib/dpkg/status

  ProblemType: Bug
  DistroRelease: Ubuntu 10.04
  Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
  ProcVersionSignature: Ubuntu 2.6.32-25.45-generic 2.6.32.21+drm33.7
  Uname: Linux 2.6.32-25-generic i686
  Architecture: i386
  Date: Wed Nov 24 19:08:01 2010
  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/df-libreoffice/+bug/681080/+subscriptions