Bastiaan J. Braams, thank you for taking the time to report this and helping to
make Ubuntu better. Please execute the following command, as it will
automatically gather debugging information, in a terminal:
apport-collect 1261048
When reporting bugs in the future please use apport by using 'ubuntu-bug' and
the name of the package affected. You can learn more about this functionality
at https://wiki.ubuntu.com/ReportingBugs.
** Tags removed: 12.04-lts calc ceiling even floor functions int libreoffice
odd rounddown roundup trunc
** Tags added: precise
** Changed in: libreoffice (Ubuntu)
Status: New => Incomplete
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1261048
Title:
Wrong results from rounding functions for large argument
Status in “libreoffice” package in Ubuntu:
Incomplete
Bug description:
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) are exactly representable. Therefore I expect that
rounding y to integer will return y exactly, for any of the functions
roundup, rounddown, trunc, ceiling, floor and int. I also expect that
even(y)=y+1 and odd(y)=y.
Actual results: functions roundup(y,0), rounddown(y,0), trunc(y,0),
ceiling(y,1), floor(y,1) and int(y) all return y+5. Moreover,
even(y)=y and odd(y)=y+6 according to Calc.
(Note that the second argument to roundup, rounddown and trunc
indicates number of places behind the decimal symbol and the second
argument to ceiling and floor indicates the unit.)
There are similar problems with these rounding functions when rounding
to some number (>0) of places behind the decimal symbol.
I have placed a *.ods spreadsheet that shows the issues in two places
for public access:
https://drive.google.com/file/d/0B36cHU4sR7HmS25tcXh5WTg1Q1U/edit?usp=sharing
https://www.dropbox.com/s/uy0hzgginny4fuc/LibreOfficeRoundingIssues.ods
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1261048/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
