[gnumeric] Fix std error for intercept in non-affine case of LINEST. [#550933]

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

commit 166ed898a2099effaf1d5a199a5b47d1c2a4399d
Author: Andreas J. Guelzow <aguelzow pyrshep ca>
Date:   Wed Jul 1 16:27:54 2009 -0600

    Fix std error for intercept in non-affine case of LINEST. [#550933]
    
    2009-07-01  Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* functions.c (gnumeric_linest): in the non-affine case the
    	  intercept has no (non-zero) standard error
    
    2009-07-01 Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* numtheory.c (help_sigma): escape argument name

 NEWS                          |    1 +
 plugins/fn-stat/ChangeLog     |    5 +++++
 plugins/fn-stat/functions.c   |    3 ++-
 plugins/numtheory/ChangeLog   |    6 +++++-
 plugins/numtheory/numtheory.c |    8 ++++----
 5 files changed, 17 insertions(+), 6 deletions(-)
---
diff --git a/NEWS b/NEWS
index a1f3422..71291fb 100644
--- a/NEWS
+++ b/NEWS
@@ -13,6 +13,7 @@ Andreas:
 	* Fix "not-between" conditional styles. [#586818]
 	* Show existence of conditional styles in format dialog.
 	* Add an initialy hidden long format toolbar.
+	* Fix std error for intercept in non-affine case of LINEST. [#550933]
 
 Morten:
 	* Make SUMIF/COUNTIF and the D* functions understand pattern. [#586215]
diff --git a/plugins/fn-stat/ChangeLog b/plugins/fn-stat/ChangeLog
index fa3f0ae..3449139 100644
--- a/plugins/fn-stat/ChangeLog
+++ b/plugins/fn-stat/ChangeLog
@@ -1,3 +1,8 @@
+2009-07-01  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* functions.c (gnumeric_linest): in the non-affine case the 
+	  intercept has no (non-zero) standard error
+	
 2009-06-21  Andreas J. Guelzow <aguelzow pyrshep ca>
 
 	* functions.c: use GNM_FUNC_HELP_EXCEL throughout and add a
diff --git a/plugins/fn-stat/functions.c b/plugins/fn-stat/functions.c
index e5a8d03..261070f 100644
--- a/plugins/fn-stat/functions.c
+++ b/plugins/fn-stat/functions.c
@@ -3374,7 +3374,8 @@ gnumeric_linest (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
 			value_array_set (result, dim - i - 1, 1,
 					 value_new_float (extra_stat->se[i+affine]));
 		value_array_set (result, dim, 1,
-				 value_new_float (extra_stat->se[0]));
+				 affine ? value_new_float (extra_stat->se[0]) 
+				 : value_new_error_NA (ei->pos));
 	} else
 		result = value_new_array (dim + 1, 1);
 
diff --git a/plugins/numtheory/ChangeLog b/plugins/numtheory/ChangeLog
index dfed49c..ef9a947 100644
--- a/plugins/numtheory/ChangeLog
+++ b/plugins/numtheory/ChangeLog
@@ -1,6 +1,10 @@
+2009-07-01 Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* numtheory.c (help_sigma): escape argument name
+
 2009-06-29 Andreas J. Guelzow <aguelzow pyrshep ca>
 
-	* numtheory.c (help_d): change to new type of descriptionfix example
+	* numtheory.c (help_d): fix example
 
 2009-06-28 Andreas J. Guelzow <aguelzow pyrshep ca>
 
diff --git a/plugins/numtheory/numtheory.c b/plugins/numtheory/numtheory.c
index 3c87695..9c167ac 100644
--- a/plugins/numtheory/numtheory.c
+++ b/plugins/numtheory/numtheory.c
@@ -322,11 +322,11 @@ gnumeric_d (GnmFuncEvalInfo *ei, GnmValue const * const *args)
 /* ------------------------------------------------------------------------- */
 
 static GnmFuncHelp const help_sigma[] = {
-	{ GNM_FUNC_HELP_NAME, F_("NT_SIGMA:sigma function")},
-	{ GNM_FUNC_HELP_ARG, F_("n:positive integer")},
-	{ GNM_FUNC_HELP_DESCRIPTION, F_("NT_SIGMA calculates the sum of the divisors of @n.")},
+	{ GNM_FUNC_HELP_NAME, F_("NT_SIGMA:sigma function") },
+	{ GNM_FUNC_HELP_ARG, F_("n:positive integer") },
+	{ GNM_FUNC_HELP_DESCRIPTION, F_("NT_SIGMA calculates the sum of the divisors of @{n}.") },
 	{ GNM_FUNC_HELP_EXAMPLES, "=NT_SIGMA(4)" },
-	{ GNM_FUNC_HELP_SEEALSO, "NT_D,ITHPRIME,NT_PHI"},
+	{ GNM_FUNC_HELP_SEEALSO, "NT_D,ITHPRIME,NT_PHI" },
 	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Divisor_function") },
 	{ GNM_FUNC_HELP_END }
 };