[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
Synchronising bug status with upstream. ** Changed in: libreoffice (Ubuntu) Status: Incomplete => Fix Released -- 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: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
Launchpad has imported 10 comments from the remote bug at https://bugs.documentfoundation.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-21T03: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/ubuntu/+source/libreoffice/+bug/891812/comments/3 On 2011-11-21T03: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/ubuntu/+source/libreoffice/+bug/891812/comments/4 On 2011-11-21T03: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/ubuntu/+source/libreoffice/+bug/891812/comments/5 On 2011-11-21T16: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/ubuntu/+source/libreoffice/+bug/891812/comments/10 On 2011-11-24T10:15:51+00:00 Björn Michaelsen wrote: Thanks Markus. Adjusting importance accordingly. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/891812/comments/12 On 2011-11-25T11:33:42+00:00 Bastiaan J. Braams wrote: The presumed cause of the bug is that the multinomial is computed as a ratio of factorials; this would indeed cause an overflow when the sum of the arguments exceeds 170. Please note that for the implementation of the Binomial in LibreOffice Calc (function COMBIN) no such restriction applies; it is computed carefully to avoid unnecessary overflow. Please note also that the bug with multinomial would be almost trivial to fix. A recurrence for computing the multinomial function as a product of binomials may be found in the description of the multinomial function in the Sage mathematics system: http://www.sagemath.org/doc/reference/sage/rings/arith.html#sage.rings.arith.multinomial The associated 5-line Python code by Gabriel Ebner may be found here: http://trac.sagemath.org/sage_trac/attachment/ticket/3132/trac3132-2.diff I believe that this is a very natural way to compute the multinomial, and it would completely remove the problem of unnecessary overflow. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/891812/comments/14 On 2011-11-25T21:57:43+00:00 Markus Mohrhard wrote: Feel free to implement it. Source code for this function is at: http://opengrok.libreoffice.org/xref/core/scaddins/source/analysis/analysis.cxx#690 I'm looking forward to your contribution. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/891812/comments/16 On 2012-07-31T23:43:33+00:00 Thuswa wrote: Proposed fix: https://gerrit.libreoffice.org/#/c/353 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/891812/comments/19 On 2012-08-02T23:17:02+00:00 Thuswa wrote: Created attachment 65063 Test file to check algorithm Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/891812/comments/20 On 2012-08-10T14:11:49+00:00 Libreoffice-bugs wrote: Albert Thuswaldner committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1f62afae0fd04236005be70736cf7ab059a10778 fdo#43135 - fix for
[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
** Bug watch added: Document Foundation Bugzilla #43135 https://bugs.documentfoundation.org/show_bug.cgi?id=43135 ** Changed in: df-libreoffice Importance: Wishlist => Unknown ** Changed in: df-libreoffice Status: Confirmed => Unknown ** Changed in: df-libreoffice Remote watch: freedesktop.org Bugzilla #43135 => Document Foundation Bugzilla #43135 -- 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: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know. ** Changed in: libreoffice (Ubuntu) Status: Triaged => 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: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
** Changed in: df-libreoffice Importance: Medium = Wishlist -- 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: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
Feel free to implement it. I appreciate the suggestion and the pointer to the code. I can see how the computation is done; a ratio of factorials indeed. However, there is a lot of code surrounding the core numerical computation that is quite mysterious to me. So, with due respect for the creators and developers of LibreOffice Calc I have to decline to touch the code myself. -- 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: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 891812] Re: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170
** Summary changed: - [Upstream] Calc: multinomial(1000,0) returns Err502 instead of 1 + [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 -- 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: [Upstream] Calc: MULTINOMIAL only supports parameters up to 170 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/891812/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs