Christoph Arenz, thank you for reporting this bug and helping make Ubuntu better. Regarding the attached file opened using 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 1) notice Sheet 1, cell B19 has 5 when it should throw an error, as the formula: =DCOUNT(A4:E13,0,A16:E17) is pointing to a column of 0. Same issue with cell C50. This bug will focus on this issue. Sheet1, Cells C32-C35 are malformed expressions as I converted them to Excel and they produced 0's all the way down. Please see Microsoft's website for information on DCOUNT syntax: http://office.microsoft.com /en-us/excel-help/dcount-HP005209049.aspx lsb_release -rd Description: Ubuntu 11.04 Release: 11.04 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 apt-cache policy unoconv unoconv: Installed: 0.3-6 Candidate: 0.3-6 Version table: *** 0.3-6 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages 100 /var/lib/dpkg/status apt-cache policy wine1.3 wine1.3: Installed: 1.3.19-0ubuntu1~maverick1~ppa1 Candidate: 1.3.19-0ubuntu1~maverick1~ppa1 Version table: *** 1.3.19-0ubuntu1~maverick1~ppa1 0 100 /var/lib/dpkg/status 1.3.15-0ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages ** Changed in: libreoffice (Ubuntu) Status: New => Confirmed ** Summary changed: - oocalc: wrong calculation with DCOUNT and DCOUNTA function + Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17) -- 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
