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 553044 - Allow creating array/ranges from arbitrary expressions
Allow creating array/ranges from arbitrary expressions
Status: RESOLVED DUPLICATE of bug 570689
Product: Gnumeric
Classification: Applications
Component: Main System
git master
Other All
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-09-20 20:04 UTC by Michael Goetze
Modified: 2010-07-13 07:44 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Michael Goetze 2008-09-20 20:04:39 UTC 
Currently, I have to clutter up my Spreadsheet with a lot of temporary results to calculate rates of return. It would be much nicer and more convenient to be able to write formulas like:

=XIRR((A1*A2,-B1,C3),(D1,'2008-01-01',D2))
Comment 1 Morten Welinder 2008-09-21 21:07:55 UTC 
Retitling -- this is really unrelated to XIRR.
Comment 2 Andreas J. Guelzow 2010-07-13 07:44:03 UTC 
Thanks for taking the time to report this bug.
This particular bug has already been reported into our bug tracking system, but we are happy to tell you that the problem has already been fixed. It should be solved in the next software version. You may want to check for a software upgrade.

You could now write (to use your example):

=XIRR(array(A1*A2,-B1,C3),array(D1,'2008-01-01',D2))

*** This bug has been marked as a duplicate of bug 570689 ***