desktop-packages team mailing list archive

[Björn Michaelsen <bjoern.michaelsen@xxxxxxxxxxxxx>]

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

-- 
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:
  Won't Fix

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