** Description changed:
Binary package hint: openoffice.org-calc
+ Binary package hint: libreoffice
- In 32-bit Ubuntu 10.10, in OpenOffice Calc (version 1:3.2.1-7ubuntu1)
- the N() function doesn't work as expected. The function should return
- "0" for non-number input, but sometimes returns "#VALUE!" or "0E+000",
- which denies its purpose (and makes a lot of my documents completly
- unusable). This function worked fine with OOo that was shipped in 10.04.
+ 1) lsb_release -rd
+ Description: Ubuntu 10.10
+ Release: 10.10
- In test example I provided as attachment (TestingN.ods), you could see
- (I hope) that same formula "=N(O4)" sometimes gives "#VALUE!", sometimes
- "0E+000", depending on which cell I put it in. It should ALWAYS be "0".
- I tested this on two machines, one was 10.10 upgraded form 10.04, the
- other one was a fresh install of 10.10. I uninstalled Ubuntu's version
- and installed OOo 3.2.1 from www.openoffice.org (OOO320m18 build 9502)
- and this version works as expected.
+ 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).
** Changed in: libreoffice (Ubuntu)
Status: New => Confirmed
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/686649
Title:
Calc N() function doesn't work
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
