← Back to team overview

desktop-packages team mailing list archive

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

 

Launchpad has imported 4 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=37218.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-05-15T09:19:53+00:00 Christopher M. Penalver wrote:

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.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/377215/comments/3

------------------------------------------------------------------------
On 2011-05-16T17:34:20+00:00 Pmladek-y wrote:

It works with =TINV(0.05;10000).

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

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/377215/comments/4

------------------------------------------------------------------------
On 2011-07-20T10:56:20+00:00 Markus-mohrhard wrote:

sent a possible fix to the ML for review

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/377215/comments/5

------------------------------------------------------------------------
On 2011-07-22T17:45:20+00:00 Markus-mohrhard wrote:

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

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/377215/comments/6

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

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

Status in LibreOffice Productivity Suite:
  Fix Released
Status in The OpenOffice.org Suite:
  Invalid
Status in “gnumeric” package in Ubuntu:
  Invalid
Status in “libreoffice” package in Ubuntu:
  Fix Released
Status in “openoffice.org” package in Ubuntu:
  Won't Fix

Bug description:
  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

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/377215/+subscriptions