Bug 37218 - EDITING function =TINV(0.05;100000) gets Error:502
Summary: EDITING function =TINV(0.05;100000) gets Error:502
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.2 release
Hardware: x86 (IA32) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:3.5 target:3.4.3
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-15 02:19 UTC by Chris Peñalver
Modified: 2011-12-23 14:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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