[gnumeric] A LOTUS123 function translation addition.

[Andreas J. Guelzow <guelzow src gnome org>]

commit 5b4fed9b3fbc983dddb9a1ea6774679d5fef433d
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Thu May 5 11:52:35 2011 -0600

    A LOTUS123 function translation addition.
    
     2011-05-05  Andreas J Guelzow  <aguelzow pyrshep ca>
    
    	* lotus-formula.c (functions): add SHEETS and 2 comments

 plugins/lotus-123/ChangeLog       |    4 ++++
 plugins/lotus-123/lotus-formula.c |    4 +++-
 2 files changed, 7 insertions(+), 1 deletions(-)
---
diff --git a/plugins/lotus-123/ChangeLog b/plugins/lotus-123/ChangeLog
index 9f5c0bc..9f1c55f 100644
--- a/plugins/lotus-123/ChangeLog
+++ b/plugins/lotus-123/ChangeLog
@@ -1,3 +1,7 @@
+2011-05-05  Andreas J Guelzow  <aguelzow pyrshep ca>
+
+	* lotus-formula.c (functions): add SHEETS and 2 comments
+
 2011-05-04  Morten Welinder  <terra gnome org>
 
 	* lotus.c: Add partial works supports.  Patch from Urmas
diff --git a/plugins/lotus-123/lotus-formula.c b/plugins/lotus-123/lotus-formula.c
index dde9dc1..e896978 100644
--- a/plugins/lotus-123/lotus-formula.c
+++ b/plugins/lotus-123/lotus-formula.c
@@ -139,13 +139,15 @@ static const LFuncInfo functions[] = {
 	{  1,  0x73, "@",	     "INDIRECT",     wk1_std_func },
 	{  3,  0x74, "RATE",	     "RATE",	     wk1_rate_func },
 	{  3,  0x75, "TERM",	     NULL,	     wk1_std_func },
+	/* TERM ($1,$2,$3) is NPER ($2,$1,0,$3) */
 	{  3,  0x76, "CTERM",	     NULL,	     wk1_nper_func },
+	/* CTERM ($1,$2,$3) is NPER ($1,0,$3,$2) */
 	{  3,  0x77, "SLN",	     "SLN",	     wk1_std_func },
 	{  4,  0x78, "SYD",	     "SYD",	     wk1_std_func },
 	{  4,  0x79, "DDB",	     "DDB",	     wk1_std_func },
 	/* 0x7A is SPLFUNC which needs special handling */
 	/* WK4 and up.	This list from wkrel9.txt */
-	{  1,  0x7B, "SHEETS",	     NULL,	     wk1_std_func },
+	{  1,  0x7B, "SHEETS",	     "SHEETS",	     wk1_std_func },
 	{  1,  0x7C, "INFO",	     "INFO",	     wk1_std_func },
 	{ -1,  0x7D, "SUMPRODUCT",   "SUMPRODUCT",   wk1_std_func },
 	{  1,  0x7E, "ISRANGE",	     "ISREF",	     wk1_std_func },