← Back to team overview

desktop-packages team mailing list archive

[Bug 686649] Re: [Upstream] Calc N() function doesn't work

 

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