desktop-packages team mailing list archive

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

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix  

If the problem persists, please mark this bug as "also affects project
Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that
has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to
allow cross pollination.

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