Ubuntu
openoffice.org package

[Upstream] Calc N() function doesn't work

Bug #686649 reported by zzarko on 2010-12-07

This bug affects 2 people

	Status	Importance	Assigned to
LibreOffice	Fix Released	Medium	freedesktop-bugs #33705
OpenOffice	Fix Released	Low	auto-openoffice.org #109861
libreoffice (Ubuntu)	Fix Released	Medium	Unassigned
openoffice.org (Ubuntu)	Won't Fix	Undecided	Unassigned

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).

See original description

Tags:

Revision history for this message

zzarko (zzarko-gmail) wrote on 2010-12-07:

TestingN.ods Edit (27.6 KiB, application/vnd.oasis.opendocument.spreadsheet)

Bug Watch Updater (bug-watch-updater) on 2011-02-09

Changed in libreoffice:
importance:	Unknown → Medium
status:	Unknown → Confirmed

penalvch (penalvch) on 2011-02-16

affects:	libreoffice → df-libreoffice
tags:	added: lo33
summary:	- In OpenOffice Calc 3.2.1 N() function doesn't work + Calc N() function doesn't work

penalvch (penalvch) on 2011-03-03

description:	updated
Changed in libreoffice (Ubuntu):
status:	New → Confirmed

Revision history for this message

zzarko (zzarko-gmail) wrote on 2011-05-22: Re: Calc N() function doesn't work

Just to confirm that this bug remains in LibreOffice in final version of Ubuntu 11.04. OpenOffice 3.3.0 from OpenOffice.org works fine.

penalvch (penalvch) on 2011-05-22

Changed in libreoffice (Ubuntu):
importance:	Undecided → Medium
status:	Confirmed → Triaged

Bug Watch Updater (bug-watch-updater) on 2011-05-22

Changed in openoffice:
importance:	Unknown → Low
status:	Unknown → Fix Released

Bug Watch Updater (bug-watch-updater) on 2011-05-24

Changed in df-libreoffice:
status:	Confirmed → In Progress

Bug Watch Updater (bug-watch-updater) on 2011-06-09

Changed in df-libreoffice:
status:	In Progress → Fix Released

penalvch (penalvch) on 2011-06-11

summary:

- Calc N() function doesn't work
+ [Upstream] Calc N() function doesn't work

Revision history for this message

Korrawit Pruegsanusak (detective-conan-1412) wrote on 2011-09-10:

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

Björn Michaelsen (bjoern-michaelsen) on 2011-09-15

Changed in openoffice.org (Ubuntu):
status:	New → Won't Fix

Revision history for this message

Björn Michaelsen (bjoern-michaelsen) wrote on 2011-09-15: migrating packaging from OpenOffice.org to Libreoffice

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.