Comment 8 for bug 681080

Revision history for this message
In , penalvch (penalvch) 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.