Public bug reported:
Frankly I have no idea if my bug report is new or old. The sound through
my speakers is awful, crackling and with frequent interruptions
(duration just a fraction of a second). I am on an Ubuntu 14.04.1
system. I would need some guidance about what else to report and about
Thank you Christopher M. Penalver for the guidance towards a more
streamlined problem report. Row 5 in the posted spreadsheet,
LibreOfficeRoundingIssues.ods, shows the precise errors described in my
initial report here. The cells in that row contain, successively, x=50,
y=power(2,x)+1,
I have filed Bugzilla - Bug 73410 - Wrong results from rounding
functions for large argument. Filed under LibreOffice Spreadsheet. Link:
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=73410.
** Bug watch added: LibreOffice Bugzilla #73410
I have filed a report - Wrong results from rounding functions for large
argument - to Bugzilla. Filed under LibreOffice Spreadsheet. Link:
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=73410.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is
apport information
** Tags added: apport-collected running-unity
** Description changed:
I am using Ubuntu 12.04.3 LTS and within that LibreOffice 3.5.7.2, Build
ID: 350m1(Build:2). This report concerns LibreOffice Calc; functions
roundup, rounddown, trunc, ceiling, floor, int, even and
** Tags added: 12.04-lts calc ceiling even floor functions int
libreoffice odd rounddown roundup trunc
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1261048
Title:
Wrong results from rounding
Public bug reported:
I am using Ubuntu 12.04.3 LTS and within that LibreOffice 3.5.7.2, Build
ID: 350m1(Build:2). This report concerns LibreOffice Calc; functions
roundup, rounddown, trunc, ceiling, floor, int, even and odd.
Let y=power(2,50)+1 and please note that all integers up to power(2,53)
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
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
Thanks to Ch. Penalver for re-writing my bug report into the proper
style. I hope that someone more experienced (than I) in the submitting
of bug reports can take it upstream to libreoffice-calc.
A recurrence for computing the multinomial function as a product of
binomials may be found in the
Public bug reported:
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
11 matches
Mail list logo
