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 554732 - XIRR doesn't handle blank dates (Excel 2002 does)
XIRR doesn't handle blank dates (Excel 2002 does)
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Normal minor
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-10-02 16:33 UTC by Marlon Nelson
Modified: 2008-10-03 23:56 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
xirr error demonstration (1.73 KB, application/x-gnumeric)
2008-10-02 16:34 UTC, Marlon Nelson 		Details

Description Marlon Nelson 2008-10-02 16:33:34 UTC 
XIRR should ignore blank value/date pairs

this would make it more compatible with Excel

in the spreadsheet attached, the XIRR function produces an error (#NUM!)

the purpose of including B3/A3 is so I can insert a new cash flow between rows 2 and 3, without having to update the XIRR formula

Other information:
1/1/2000	-100
1/1/2005	127
	
	=XIRR(B1:B3, A1:A3)
Comment 1 Marlon Nelson 2008-10-02 16:34:43 UTC 
Created attachment 119798 [details]
xirr error demonstration
Comment 2 Marlon Nelson 2008-10-02 16:35:15 UTC 
i'm comparing Gnumeric to Excel 2002
Comment 3 Andreas J. Guelzow 2008-10-02 16:49:22 UTC 
Note that OOo also ignores empty cells here.
Comment 4 Morten Welinder 2008-10-02 17:04:05 UTC 
Probably not too hard.  We have the machinery for this.
Comment 5 Morten Welinder 2008-10-03 23:56:00 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.