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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/891812 Title: Calc: multinomial(1000,0) returns Err502 instead of 1 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
