** Description changed: 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 + 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. + 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 + 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
-- 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
