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 132347 - formula guru lists incorrect argument names for rate() function
formula guru lists incorrect argument names for rate() function
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
1.2.x
Other Linux
: Normal minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2004-01-24 00:24 UTC by John Steele Scott
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description John Steele Scott 2004-01-24 00:24:26 UTC 
In a new spreadsheet, use the Insert->Function menu item. The function 
selector appears. Select "Finance" as the category, and select "rate" as 
the function. Note the description: RATE(nper,pmt,pv[,fv,type,guess]). 
Click "Insert". The "Formula Guru" window lists the first arguments as 
(rate,nper,pmt[,fv,type,guess]). 
 
From looking at gnumeric_rate() in plugins/fn-financial/functions.c, I see 
that the correct arguments are (nper,pmt,pv[,fv,type,guess]), and so the 
formula guru is being supplied with wrong information somehow.
Comment 1 Andreas J. Guelzow 2004-01-24 01:35:51 UTC 
According to the function definition we have:

	{ "rate", "fff|fff", "rate,nper,pmt,fv,type,guess",
	  &help_rate,	  gnumeric_rate, NULL, NULL, NULL, NULL,
	  GNM_FUNC_SIMPLE + GNM_FUNC_AUTO_PERCENT,
	  GNM_FUNC_IMPL_STATUS_COMPLETE, GNM_FUNC_TEST_STATUS_BASIC },

unfortunately the documentation text differs from this:

	N_("@FUNCTION=RATE\n"
	   "@SYNTAX=RATE(nper,pmt,pv[,fv,type,guess])\n"
	   "@DESCRIPTION="
	   "RATE calculates the rate of an investment.\n"
	   "\n"
	   "* If @nper <= 0, RATE returns #NUM! error.\n"
	   "* If @type != 0 and @type != 1, RATE returns #VALUE! error.\n"
	   "\n"
	   "@EXAMPLES=\n"
	   "\n"
	   "@SEEALSO=PV,FV")

What are the corrrect argument names ?
Comment 2 Andreas J. Guelzow 2004-01-24 06:42:54 UTC 
fixed in cvs HEAD (nper,pmt,pv[,fv,type,guess] is correct)