** Description changed:

  Binary package hint: openoffice.org
  
- If you put in a cell:
+ 1) lsb_release -rd
+ Description:  Ubuntu 11.04
+ Release:      11.04
+ 
+ 2) apt-cache policy libreoffice-calc
+ libreoffice-calc:
+   Installed: 1:3.3.2-1ubuntu5
+   Candidate: 1:3.3.2-1ubuntu5
+   Version table:
+  *** 1:3.3.2-1ubuntu5 0
+         500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 
Packages
+         100 /var/lib/dpkg/status
+      1:3.3.2-1ubuntu4 0
+         500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
+ 
+ 3) What is expected to happen in LibreOffice Calc via the Terminal:
+ 
+ localc -nologo
+ 
+ cell A1 type:
  
  =TINV(0.05;100000)
  
- you will get:
+ and it reports back 1.96.
  
- Err:502. 
- I've tested in openoffice ver 3.0.0 and ver 2.4.
+ 4) What happens instead is it posts Err:502.
+ 
+ WORKAROUND: Use Gnumeric.
+ 
+ apt-cache policy gnumeric
+ gnumeric:
+   Installed: 1.10.13-1ubuntu1
+   Candidate: 1.10.13-1ubuntu1
+   Version table:
+  *** 1.10.13-1ubuntu1 0
+         500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
+         100 /var/lib/dpkg/status
+ 
+ Original Report Comments: I've tested in openoffice ver 3.0.0 and ver 2.4.
  For the same function, the Excel gets 1.96
  
  ProblemType: Bug
  Architecture: i386
  Date: Sat May 16 05:48:18 2009
  DistroRelease: Ubuntu 8.04
  NonfreeKernelModules: nvidia
  Package: openoffice.org-core 1:2.4.1-1ubuntu2.1
  PackageArchitecture: i386
  ProcEnviron:
-  
PATH=/usr/lib/openoffice/program:/usr/local/Trolltech/Qt-4.4.3/bin:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
-  LANG=pt_BR.UTF-8
-  SHELL=/bin/bash
+  
PATH=/usr/lib/openoffice/program:/usr/local/Trolltech/Qt-4.4.3/bin:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
+  LANG=pt_BR.UTF-8
+  SHELL=/bin/bash
  SourcePackage: openoffice.org
  Uname: Linux 2.6.24-24-generic i686

** Changed in: libreoffice (Ubuntu)
   Importance: Undecided => Medium

** Changed in: libreoffice (Ubuntu)
       Status: New => Triaged

** Summary changed:

- [upstream] function TINV gets Error:502
+ [upstream] function =TINV(0.05;100000) gets Error:502

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/377215

Title:
  [upstream] function =TINV(0.05;100000) gets Error:502

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to