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

[Ricardo Moretzsohn]

Binary package hint: openoffice.org

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)

and it reports back 1.96.

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
SourcePackage: openoffice.org
Uname: Linux 2.6.24-24-generic i686

[Chris Cheney (ccheney)]

It changes to Error:502 after 99999 to 100000. This is probably an upstream issue.

[penalvch (penalvch)]

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/377215

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)

and it reports back 1.96, as it does in Excel.

4) What happens instead is it posts Err:502.

[Pmladek-y (pmladek-y)]

It works with =TINV(0.05;10000).

Kohei, is it possible that LO does not support such high values like 100000?

[Markus Mohrhard (moggi)]

sent a possible fix to the ML for review

[Markus Mohrhard (moggi)]

upper limit is set to 1E10 now, same as in Excel

[Björn Michaelsen (bjoern-michaelsen)]

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

[penalvch (penalvch)]

No reference URL.

[Björn Michaelsen (bjoern-michaelsen)]

Fix is claimed to be released upstream with 3.4.3 which is released in oneiric.