← Back to team overview

desktop-packages team mailing list archive

  1. desktop-packages team
  2. Mailing list archive
  3. Message #80069

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

  Thread Previous • Date Previous • • Thread Next 
Launchpad has imported 6 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=37256.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-05-16T07:04:10+00:00 Christopher M. Penalver wrote:

Created attachment 46765
OO_DCOUNT_problem_2.ods

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/681080

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/3

------------------------------------------------------------------------
On 2011-07-20T03:08:25+00:00 Markus Mohrhard wrote:

this is not a bug

as
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DCOUNT_function
mentions 0 is used for all columns

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/7

------------------------------------------------------------------------
On 2011-07-21T08:39:44+00:00 Christopher M. Penalver wrote:

(In reply to comment #1)
> this is not a bug
> 
> as
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DCOUNT_function
> mentions 0 is used for all columns

markus.mohrhard@xxxxxxxxxxxxxx, as mentioned in the above link:
"Issues:

The exact use of 0 as the field parameter is unclear, both in operation
and in compatibility (issue 84168)".

As well, Microsoft clears up what it means via:
http://office.microsoft.com/en-us/excel-help/dcount-HP005209049.aspx

The field parameter is not supposed to have a 0 in it as field is the
column to use. A 0 column does not make sense. Hence, LO should throw an
error for Excel compatibility reasons (Gnumeric also throws the error
appropriately).

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/8

------------------------------------------------------------------------
On 2011-08-02T15:55:51+00:00 Markus Mohrhard wrote:

No we are not Excel and we have our own formula api. As mentionen in the
link I posted O is allowed and refers to all columns.

This is not a bug but a feature! We are not a excel copy so we don't
need to behave in the same way.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/9

------------------------------------------------------------------------
On 2011-08-02T18:51:59+00:00 Christopher M. Penalver wrote:

markus.mohrhard@xxxxxxxxxxxxxx, thank you for your attention on this
issue.

(In reply to comment #3)
> No we are not Excel and we have our own formula api.

I never said LibreOffice was Excel.

> As mentionen in the link I posted O is allowed and refers to all
columns.

While 0 is currently allowed, it does not hold compatibility with Excel
or Gnumeric as noted in Comment #2.

> This is not a bug but a feature!

Ok, this bug has been remarked as ENHANCEMENT.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/10

------------------------------------------------------------------------
On 2014-11-04T03:32:43+00:00 Jmadero-dev wrote:

As Markus already explained that this is a feature - it's not getting
changed. Markus is one of our most experienced developers. Please don't
reopen the bug.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/13


** Changed in: df-libreoffice
       Status: Confirmed => 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/681080

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

Status in LibreOffice Productivity Suite:
  Invalid
Status in “gnumeric” package in Ubuntu:
  Invalid
Status in “libreoffice” package in Ubuntu:
  Won't Fix
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
  Thread Previous • Date Previous • • Thread Next