desktop-packages team mailing list archive

["Christopher M. Penalver" <christopher.penalver@xxxxxxx>]

Bastiaan J. Braams, thank you for taking the time to report this bug and
helping to make Ubuntu better. The issue you are reporting is an
upstream one and it would be nice if somebody having it could send the
bug to the developers of the software by following the instructions at
http://wiki.documentfoundation.org/BugReport . If you have done so,
please tell us the number of the upstream bug (or the link), so we can
add a bugwatch that will inform us about its status. Thanks in advance.

** Description changed:

- The multinomial function is defined as a ratio of factorial functions, but that is not how it should be computed; it would cause unnecessary overflow. However, the following expression causes a numerical error (#502):
+ 1) lsb_release -rd
+ Description:	Ubuntu 11.10
+ Release:	11.10
+ 
+ 2) 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)
- The correct mathematical value is just 1 and that was the expected result.
  
- Note that, for example, multinomial(100,0) is computed correctly; the
- value is 1.
+ it returns 1.
  
- In general the multinomial may be computed as a product of binomials, by recursion on the number of variables.
- I'm using Ubuntu 11.10 and LibreOffice Calc 3.4.3, OOO340m1 (Build:302).
+ 4) What happens instead is it returns error (#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

** Changed in: libreoffice (Ubuntu)
   Importance: Undecided => Medium

** Changed in: libreoffice (Ubuntu)
       Status: New => Triaged

** Summary changed:

- calc: numerical error in the multinomial function
+ Calc: multinomial(1000,0) returns Err502 instead of 1

** Description changed:

  1) lsb_release -rd
  Description:	Ubuntu 11.10
  Release:	11.10
  
  2) 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
+   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 error (#502).
+ 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

** Also affects: df-libreoffice
   Importance: Undecided
       Status: New

** Changed in: df-libreoffice
       Status: New => Incomplete

-- 
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:
  Calc: multinomial(1000,0) returns Err502 instead of 1

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

Bug description:
  1) lsb_release -rd
  Description:	Ubuntu 11.10
  Release:	11.10

  2) 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