| 2013-12-14 23:13:50 |
Bastiaan J. Braams |
bug |
|
|
added bug |
| 2014-01-05 15:53:13 |
Bastiaan J. Braams |
tags |
|
12.04-lts calc ceiling even floor functions int libreoffice odd rounddown roundup trunc |
|
| 2014-01-05 16:01:36 |
penalvch |
tags |
12.04-lts calc ceiling even floor functions int libreoffice odd rounddown roundup trunc |
precise |
|
| 2014-01-05 16:03:00 |
penalvch |
libreoffice (Ubuntu): status |
New |
Incomplete |
|
| 2014-01-06 19:27:03 |
Bastiaan J. Braams |
tags |
precise |
apport-collected precise running-unity |
|
| 2014-01-06 19:27:04 |
Bastiaan J. Braams |
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 |
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
---
ApportVersion: 2.0.1-0ubuntu17.6
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04.3 LTS "Precise Pangolin" - Release i386 (20130820.1)
MarkForUpload: True
Package: libreoffice 1:3.5.7-0ubuntu5
PackageArchitecture: i386
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.8.0-35.50~precise1-generic 3.8.13.13
Tags: precise running-unity
Uname: Linux 3.8.0-35-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo |
|
| 2014-01-06 19:27:05 |
Bastiaan J. Braams |
attachment added |
|
Dependencies.txt https://bugs.launchpad.net/bugs/1261048/+attachment/3942052/+files/Dependencies.txt |
|
| 2014-01-06 19:48:34 |
penalvch |
attachment added |
|
LibreOfficeRoundingIssues.ods https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1261048/+attachment/3942054/+files/LibreOfficeRoundingIssues.ods |
|
| 2014-01-06 19:48:55 |
penalvch |
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
---
ApportVersion: 2.0.1-0ubuntu17.6
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04.3 LTS "Precise Pangolin" - Release i386 (20130820.1)
MarkForUpload: True
Package: libreoffice 1:3.5.7-0ubuntu5
PackageArchitecture: i386
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.8.0-35.50~precise1-generic 3.8.13.13
Tags: precise running-unity
Uname: Linux 3.8.0-35-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo |
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.
Example:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1261048/+attachment/3942054/+files/LibreOfficeRoundingIssues.ods
---
ApportVersion: 2.0.1-0ubuntu17.6
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04.3 LTS "Precise Pangolin" - Release i386 (20130820.1)
MarkForUpload: True
Package: libreoffice 1:3.5.7-0ubuntu5
PackageArchitecture: i386
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.8.0-35.50~precise1-generic 3.8.13.13
Tags: precise running-unity
Uname: Linux 3.8.0-35-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo |
|
| 2014-01-08 19:43:07 |
penalvch |
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.
Example:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1261048/+attachment/3942054/+files/LibreOfficeRoundingIssues.ods
---
ApportVersion: 2.0.1-0ubuntu17.6
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04.3 LTS "Precise Pangolin" - Release i386 (20130820.1)
MarkForUpload: True
Package: libreoffice 1:3.5.7-0ubuntu5
PackageArchitecture: i386
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.8.0-35.50~precise1-generic 3.8.13.13
Tags: precise running-unity
Uname: Linux 3.8.0-35-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo |
1) lsb_release -rd
Description: Ubuntu Trusty Tahr (development branch)
Release: 14.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:4.1.3-0ubuntu3
Candidate: 1:4.1.3-0ubuntu3
Version table:
*** 1:4.1.3-0ubuntu3 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages
100 /var/lib/dpkg/status
I am using Ubuntu 12.04.3 LTS and within that LibreOffice 3.5.7.2, Build ID: 350m1(Build:2) but this is also reproducible in LO Trunk 4.3.0.0.alpha0+ on Windows Vista:
What is expected to happen at a terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1261048/+attachment/3942054/+files/LibreOfficeRoundingIssues.ods && localc --nologo LibreOfficeRoundingIssues
Is that for cell D5 is it 0.
What happens instead is that it is 5. This would be an issue with Calc numerical precision, as the actual outcome of 5 is also the same with Excel.
WORKAROUND: Use gnumeric:
apt-cache policy gnumeric
gnumeric:
Installed: 1.12.9-1
Candidate: 1.12.9-1
Version table:
*** 1.12.9-1 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/universe amd64 Packages
100 /var/lib/dpkg/status
---
ApportVersion: 2.0.1-0ubuntu17.6
Architecture: i386
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04.3 LTS "Precise Pangolin" - Release i386 (20130820.1)
MarkForUpload: True
Package: libreoffice 1:3.5.7-0ubuntu5
PackageArchitecture: i386
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.8.0-35.50~precise1-generic 3.8.13.13
Tags: precise running-unity
Uname: Linux 3.8.0-35-generic i686
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo |
|
| 2014-01-08 19:44:15 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Wishlist |
|
| 2014-01-08 19:44:15 |
penalvch |
libreoffice (Ubuntu): status |
Incomplete |
Won't Fix |
|
| 2014-01-08 21:26:52 |
Bastiaan J. Braams |
bug watch added |
|
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=73410 |
|
| 2014-01-08 21:46:37 |
penalvch |
bug task added |
|
df-libreoffice |
|
| 2014-01-08 21:46:50 |
penalvch |
summary |
Wrong results from rounding functions for large argument |
[Upstream] Wrong results from rounding functions for large argument |
|
| 2014-01-08 23:33:00 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
| 2014-01-08 23:33:00 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Wishlist |
|
| 2014-01-14 16:03:07 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Won't Fix |
|
| 2020-10-27 17:08:22 |
Bug Watch Updater |
df-libreoffice: status |
Won't Fix |
Invalid |
|
