2011-11-17 20:50:26 |
Bastiaan J. Braams |
bug |
|
|
added bug |
2011-11-17 22:58:44 |
penalvch |
description |
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):
=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.
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). |
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 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 |
|
2011-11-17 22:58:54 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Medium |
|
2011-11-17 22:58:54 |
penalvch |
libreoffice (Ubuntu): status |
New |
Triaged |
|
2011-11-17 23:00:30 |
penalvch |
summary |
calc: numerical error in the multinomial function |
Calc: multinomial(1000,0) returns Err502 instead of 1 |
|
2011-11-17 23:00:48 |
penalvch |
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 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 |
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 |
|
2011-11-17 23:00:56 |
penalvch |
bug task added |
|
df-libreoffice |
|
2011-11-17 23:01:30 |
penalvch |
df-libreoffice: status |
New |
Incomplete |
|
2011-11-19 12:39:32 |
Bastiaan J. Braams |
bug watch added |
|
http://trac.sagemath.org/sage_trac/attachment/ticket/3132 |
|
2011-11-21 10:57:35 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Triaged |
Incomplete |
|
2011-11-21 10:59:53 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Incomplete |
Triaged |
|
2011-11-21 11:06:27 |
Björn Michaelsen |
bug watch added |
|
https://bugs.freedesktop.org/show_bug.cgi?id=43135 |
|
2011-11-21 11:06:27 |
Björn Michaelsen |
df-libreoffice: importance |
Undecided |
Unknown |
|
2011-11-21 11:06:27 |
Björn Michaelsen |
df-libreoffice: status |
Incomplete |
Unknown |
|
2011-11-21 11:06:27 |
Björn Michaelsen |
df-libreoffice: remote watch |
|
freedesktop.org Bugzilla #43135 |
|
2011-11-21 11:12:35 |
penalvch |
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 |
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 |
|
2011-11-21 11:14:28 |
penalvch |
tags |
|
lucid oneiric xubuntu |
|
2011-11-21 11:14:48 |
penalvch |
tags |
lucid oneiric xubuntu |
lo33 lucid oneiric xubuntu |
|
2011-11-21 11:19:38 |
penalvch |
summary |
Calc: multinomial(1000,0) returns Err502 instead of 1 |
[Upstream] Calc: multinomial(1000,0) returns Err502 instead of 1 |
|
2011-11-24 06:29:16 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
2011-11-24 06:29:16 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Medium |
|
2011-11-24 18:15:24 |
Björn Michaelsen |
libreoffice (Ubuntu): importance |
Medium |
Wishlist |
|
2011-11-25 22:54:50 |
Björn Michaelsen |
summary |
[Upstream] Calc: multinomial(1000,0) returns Err502 instead of 1 |
[Upstream] Calc: MULTINOMIAL only supports parameters up to 170 |
|
2011-11-26 11:38:03 |
Bug Watch Updater |
df-libreoffice: importance |
Medium |
Wishlist |
|
2019-08-13 11:49:17 |
Marcus Tomlinson |
libreoffice (Ubuntu): status |
Triaged |
Incomplete |
|
2019-08-13 12:49:08 |
Marcus Tomlinson |
bug watch added |
|
https://bugs.documentfoundation.org/show_bug.cgi?id=43135 |
|
2019-08-13 12:49:08 |
Marcus Tomlinson |
df-libreoffice: importance |
Wishlist |
Unknown |
|
2019-08-13 12:49:08 |
Marcus Tomlinson |
df-libreoffice: status |
Confirmed |
Unknown |
|
2019-08-13 12:49:08 |
Marcus Tomlinson |
df-libreoffice: remote watch |
freedesktop.org Bugzilla #43135 |
Document Foundation Bugzilla #43135 |
|
2019-09-02 17:21:43 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Fix Released |
|
2019-09-02 17:21:43 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Wishlist |
|
2019-09-25 13:21:48 |
Marcus Tomlinson |
libreoffice (Ubuntu): status |
Incomplete |
Fix Released |
|