Upstreaming downstream discussion
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/8 :
F.H. / Björn Michaelsen, regarding the problem noted in the Description
https://bugs.freedesktop.org/show_bug.cgi?id=65082#c0 in Microsoft Office
Professional Plus 2010 Word Version 14.0.6023.1000 (32-bit):
=RATE(50,35,-250,0)
=RATE(50,36,-250,0)
=RATE(50,37,-250,0)
=RATE(50,38,-250,0)
=RATE(50,39,-250,0)
=RATE(50,40,-250,0)
all of these produce errors. This is after changing Excel Options ->
Formulas -> checked checkbox Enable iterative calculation -> Maximum
Iterations 32767 (maximum allowed by Excel) -> Maximum Change 1E-99
(maximum allowed by Excel).
In Gnumeric, the results are:
13.98%
14.38%
14.79%
15.19%
15.59%
15.99%
apt-cache policy gnumeric
gnumeric:
Installed: 1.12.1-1ubuntu1
Candidate: 1.12.1-1ubuntu1
Version table:
*** 1.12.1-1ubuntu1 0
500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages
100 /var/lib/dpkg/status
--
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/1150956
Title:
LibreOffice Calc's RATE function sometimes produces different results
as some versions of MS Office
Status in LibreOffice Productivity Suite:
Confirmed
Status in “libreoffice” package in Ubuntu:
Incomplete
Bug description:
Type "=RATE(50,35,-250,0)" on any cell, and press Enter.
The result should be 0.1398, but LibreOffice shows -1.9474!
I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu
12.04, 64-bit version, with up-to-date packages.
Reproducible in Raring.
WORKAROUND: Use Gnumeric.
apt-cache policy gnumeric
gnumeric:
Installed: 1.12.1-1ubuntu1
Candidate: 1.12.1-1ubuntu1
Version table:
*** 1.12.1-1ubuntu1 0
500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages
100 /var/lib/dpkg/status
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
