** Description changed: Binary package hint: openoffice.org - Calculations with DCOUNT or DCOUNTA function deliver wrong result. Either no occurrence is counted even if some elements of the database meet the criteria or much more occurrences are counted. Given that DCOUNT counts rows of a database -- i.e. an area -- the result should not be larger than the number of rows in that database. - Sample spreadsheet can be attached. + 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 + + 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. + + 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 + PATH=(custom, user) + LANG=en_US.utf8 + SHELL=/bin/bash SourcePackage: openoffice.org
** Tags added: lo33 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/681080 Title: Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17) -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
