Bug 37218

Summary:	EDITING function =TINV(0.05;100000) gets Error:502
Product:	LibreOffice	Reporter:	Chris Peñalver <chris>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED FIXED
Severity:	normal	CC:	kohei
Priority:	medium
Version:	3.3.2 release
Hardware:	x86 (IA32)
OS:	Linux (All)
Whiteboard:	target:3.5 target:3.4.3
Crash report or crash signature:		Regression By:

Description Chris Peñalver 2011-05-15 02:19:53 UTC

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.

Comment 1 Petr Mladek 2011-05-16 10:34:20 UTC

It works with =TINV(0.05;10000).

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

Comment 2 Markus Mohrhard 2011-07-20 03:56:20 UTC

sent a possible fix to the ML for review

Comment 3 Markus Mohrhard 2011-07-22 10:45:20 UTC

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