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 333620 - xirr gets out-of-sync when text appears in one column only
xirr gets out-of-sync when text appears in one column only
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
1.6.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2006-03-06 14:59 UTC by Andreas Hartmann
Modified: 2006-03-06 17:44 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas Hartmann 2006-03-06 14:59:03 UTC 
The xirr function treats text as a numeric value and computes wrong results.

See the example below:
In column B, xirr is expected to be computed correctly.
In column C, xirr treats "text" as a number, giving a different result.
In column D, I have let "Goal Seek..." compute the value which xirr sees for "text".

A            B       C       D
01/01/2000   -5000   -5000   -5000
16/02/2000     -10     -10     -10
28/11/2000       0   text       24.649709636828
27/06/2001     -23     -23     -23
19/01/2002     567     567     567
23/05/2003    5000    5000    5000
xirr:         3.16%   5.20%   5.20%
Comment 1 Morten Welinder 2006-03-06 16:01:40 UTC 
1. I don't get the same value in the D column as you do.  There might be
   several possible values for XIRR, so that may not be important.

2. XIRR does not invent a value for "text" -- it simply ignores the cell.
   That in turn means that the other amounts get applied to the wrong
   dates.  No good, of course.
Comment 2 Morten Welinder 2006-03-06 16:05:29 UTC 
Excel parses strings to numbers and throws #VALUE! if that fails.  That
avoids the sync problem.
Comment 3 Morten Welinder 2006-03-06 17:44:52 UTC 
fixed in cvs.