I am closing the bug task for LibreOffice because the bug has been fixed in the latest development version of Ubuntu - Oneiric Ocelot.
This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please do steps 1 and 2 of the SRU Procedure [1] to bring the need to a developer's attention. [1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure ** Changed in: libreoffice (Ubuntu) Status: Triaged => Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/686649 Title: [Upstream] Calc N() function doesn't work Status in LibreOffice Productivity Suite: Fix Released Status in The OpenOffice.org Suite: Fix Released Status in “libreoffice” package in Ubuntu: Fix Released Status in “openoffice.org” package in Ubuntu: New Bug description: Binary package hint: openoffice.org-calc Binary package hint: libreoffice 1) lsb_release -rd Description: Ubuntu 10.10 Release: 10.10 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.1-1ubuntu3~maverick1 Candidate: 1:3.3.1-1ubuntu3~maverick1 Version table: *** 1:3.3.1-1ubuntu3~maverick1 0 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages 100 /var/lib/dpkg/status OpenOffice Calc (version 1:3.2.1-7ubuntu1) apt-cache policy gnumeric gnumeric: Installed: 1.10.8-1ubuntu1 Candidate: 1.10.8-1ubuntu1 Version table: *** 1.10.8-1ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ maverick/universe i386 Packages 100 /var/lib/dpkg/status 3) What is expected to happen is when one performs at the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/686649/+attachment/1758683/+files/TestingN.ods && localc -nologo TestingN.ods the cells using the N() function show 0. 4) Instead they show either ### #VALUE! 0E+000 WORKAROUND: Use Gnumeric, OOo that was shipped in 10.04, or OOo 3.2.1 from www.openoffice.org (OOO320m18 build 9502). To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/686649/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
