After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 614257 - Export problem for XIRR, FVSCHEDULE, and XNPV
Export problem for XIRR, FVSCHEDULE, and XNPV
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: Normal critical
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-03-29 14:25 UTC by Morten Welinder
Modified: 2010-03-29 15:44 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Morten Welinder 2010-03-29 14:25:15 UTC 
1. ssconvert ../samples/excel/finfuns.xls ~/finfuns.xls
2. open resulting finfuns.xls in Excel.

=FVSCHEDULE(1,{0.09;0.11;0.1})   --> 1.09
=FVSCHEDULE(2,{0.09;0.11;0.1})   --> 2.09
=FVSCHEDULE(1,{0.07;0.11;0.16})  --> 1.07
(Strangely that is the sum of the first two numbers in the formula)

XIRR produces #N/A three times.

XNPV produces -10000 three times.

All problems go away with F2+Enter in the cells.
Comment 1 Morten Welinder 2010-03-29 15:44:56 UTC 
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.