← Back to team overview

desktop-packages team mailing list archive

[Bug 891812] Re: [Upstream] Calc: multinomial(1000, 0) returns Err502 instead of 1

 

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

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-11-21T11:02:07+00:00 Björn Michaelsen wrote:

What is expected to happen in a blank LibreOffice Calc document is when
one types in a cell:

=MULTINOMIAL(1000,0)

it returns 1.

What happens instead is it returns Err:502.

More information about multinomial may be found at:
http://help.libreoffice.org/Calc/Mathematical_Functions#MULTINOMIAL
http://office.microsoft.com/en-us/excel-help/multinomial-HP005209186.aspx

Original bug at launchpad filed against 3.4, but also reproducible in
master.

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

------------------------------------------------------------------------
On 2011-11-21T11:04:47+00:00 Björn Michaelsen wrote:

@Kohei, Eike: Please reassign (or self-assign) as appropriate.

Also: Possible regression?

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

------------------------------------------------------------------------
On 2011-11-21T11:16:54+00:00 Christopher M. Penalver wrote:

Reproducible in LibreOffice 3.3.2.

lsb_release -rd
Description: Ubuntu 10.04.3 LTS
Release: 10.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu2~lucid1
  Candidate: 1:3.3.2-1ubuntu2~lucid1
  Version table:
 *** 1:3.3.2-1ubuntu2~lucid1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status

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

------------------------------------------------------------------------
On 2011-11-22T00:23:57+00:00 Markus-mohrhard wrote:

Ok, problem is just that we only support values up to 170 as paramters
of MULTINOMIAL, I don't think that this is a regression.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/891812/comments/7


** Changed in: df-libreoffice
       Status: Unknown => Confirmed

** Changed in: df-libreoffice
   Importance: Unknown => Medium

-- 
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/891812

Title:
  [Upstream] Calc: multinomial(1000,0) returns Err502 instead of 1

Status in LibreOffice Productivity Suite:
  Confirmed
Status in “libreoffice” package in Ubuntu:
  Triaged

Bug description:
  1)
  Lucid:
  lsb_release -rd
  Description:	Ubuntu 10.04.3 LTS
  Release:	10.04

  Oneiric:
  lsb_release -rd
  Description:	Ubuntu 11.10
  Release:	11.10

  2) 
  Lucid:
  apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.2-1ubuntu2~lucid1
    Candidate: 1:3.3.2-1ubuntu2~lucid1
    Version table:
   *** 1:3.3.2-1ubuntu2~lucid1 0
          500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ lucid/main Packages
          100 /var/lib/dpkg/status

  Oneiric:
  apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.4.4-0ubuntu1~ppa1
    Candidate: 1:3.4.4-0ubuntu1~ppa1
    Version table:
   *** 1:3.4.4-0ubuntu1~ppa1 0
          500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ oneiric/main i386 Packages
          100 /var/lib/dpkg/status
       1:3.4.3-3ubuntu2 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

  LibreOffice Calc 3.4.3, OOO340m1 (Build:302)

  
  3) What is expected to happen in a blank LibreOffice Calc document is when one types in a cell:

  =MULTINOMIAL(1000,0)

  it returns 1.

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

  More information about multinomial may be found at:
  http://help.libreoffice.org/Calc/Mathematical_Functions#MULTINOMIAL
  http://office.microsoft.com/en-us/excel-help/multinomial-HP005209186.aspx

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


References