https://bugs.freedesktop.org/show_bug.cgi?id=72826
Priority: medium
Bug ID: 72826
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: rounding error in combin()
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: toralf.foers...@gmx.de
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 90913
--> https://bugs.freedesktop.org/attachment.cgi?id=90913&action=edit
calculate the odds of a german lottery
The attached file contains in sheet "analysis", N6 the value
92,520,104,463,809,100 (origin in [1])
However there are people who claim in [2] a number of 92,520,104,463,809,120
(diff is 20).
Rounding errors in column D or E might be reason - but that would mean, that MS
Excel under a different system would suffer exactly from the same issue ...
Any chance to clarify it ?
[1] https://github.com/toralf/bingo/blob/master/bingo.ods
[2]
http://www.mathematik.uni-kl.de/~ruckdesc/pubs/bingoPaper-KroisandtRuckdeschel.pdf
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
