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.
Created attachment 46765 problem_ 2.ods
OO_DCOUNT_
Downstream bug may be found at: /bugs.launchpad .net/ubuntu/ +source/ libreoffice/ +bug/681080
https:/
1_ lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc us.archive. ubuntu. com/ubuntu/ natty-proposed/main i386 Packages dpkg/status 3.3.2-1ubuntu4 0 us.archive. ubuntu. com/ubuntu/ natty/main i386 Packages
libreoffice-calc:
Installed: 1:3.3.2-1ubuntu5
Candidate: 1:3.3.2-1ubuntu5
Version table:
*** 1:3.3.2-1ubuntu5 0
500 http://
100 /var/lib/
1:
500 http://
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.