GNOME.org
 

[gnumeric] Docs: more external references.

commit dc137737a2dc8f6746fe1b4ffc472683c9664551
Author: Morten Welinder <terra gnome org>
Date:   Tue Jun 16 19:08:47 2009 -0400

    Docs: more external references.

 plugins/fn-stat/functions.c |   28 +++++++++++++++++++++++++++-
 src/func.c                  |    7 +++++--
 2 files changed, 32 insertions(+), 3 deletions(-)
---
diff --git a/plugins/fn-stat/functions.c b/plugins/fn-stat/functions.c
index 0bd7f0b..c46a3f4 100644
--- a/plugins/fn-stat/functions.c
+++ b/plugins/fn-stat/functions.c
@@ -56,6 +56,8 @@ static GnmFuncHelp const help_varp[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain number 11.4, 17.3, 21.3, 25.9, and 40.1.")},
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then VARP(A1:A5) equals 94.112")},
 	{ GNM_FUNC_HELP_SEEALSO, ("AVERAGE,DVAR,DVARP,STDEV,VAR")},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Variance") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Variance.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -82,6 +84,8 @@ static GnmFuncHelp const help_var[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.")},
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then VAR(A1:A5) equals 117.64.")},
 	{ GNM_FUNC_HELP_SEEALSO, ("VARP,STDEV")},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Variance") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Variance.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -110,6 +114,8 @@ static GnmFuncHelp const help_stdev[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.")},
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then STDEV(A1:A5) equals 10.84619749.")},
 	{ GNM_FUNC_HELP_SEEALSO, ("AVERAGE,DSTDEV,DSTDEVP,STDEVA,STDEVPA,VAR")},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Standard_deviation") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:StandardDeviation.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -135,6 +141,8 @@ static GnmFuncHelp const help_stdevp[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.")},
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then STDEVP(A1:A5) equals 9.701133954.")},	
 	{ GNM_FUNC_HELP_SEEALSO, ("STDEV,STDEVA,STDEVPA")},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Standard_deviation") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:StandardDeviation.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -261,6 +269,8 @@ static GnmFuncHelp const help_covar[] = {
 	   "B5 23.2, 25.8, 29.9, 33.5, and 42.7.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then COVAR(A1:A5,B1:B5) equals 65.858.") },
 	{ GNM_FUNC_HELP_SEEALSO, "CORREL,FISHER,FISHERINV"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Covariance") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Covariance.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -289,6 +299,8 @@ static GnmFuncHelp const help_correl[] = {
 	   "B5 23.2, 25.8, 29.9, 33.5, and 42.7.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then CORREL(A1:A5,B1:B5) equals 0.996124788.") },
 	{ GNM_FUNC_HELP_SEEALSO, "COVAR,FISHER,FISHERINV"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:CorrelationCoefficient.html") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:Covariance.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -341,6 +353,8 @@ static GnmFuncHelp const help_normsdist[] = {
 	{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("NORMSDIST(2) equals 0.977249868.") },
 	{ GNM_FUNC_HELP_SEEALSO, "NORMDIST"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Normal_distribution") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:NormalDistribution.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -357,12 +371,14 @@ gnumeric_normsdist (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
 /***************************************************************************/
 
 static GnmFuncHelp const help_normsinv[] = {
-	{ GNM_FUNC_HELP_NAME, F_("NORMSINV:inverse of the cumulative desnity function of the standard normal distribution")},
+	{ GNM_FUNC_HELP_NAME, F_("NORMSINV:inverse of the cumulative density function of the standard normal distribution")},
 	{ GNM_FUNC_HELP_ARG, F_("p:given probability")},
 	{ GNM_FUNC_HELP_NOTE, F_("If @{p} < 0 or @{p} > 1 this function returns #NUM! error.")},
 	{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("NORMSINV(0.2) equals -0.841621234.") },
 	{ GNM_FUNC_HELP_SEEALSO, "NORMDIST,NORMINV,NORMSDIST,STANDARDIZE,ZTEST"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Normal_distribution") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:NormalDistribution.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -391,6 +407,8 @@ static GnmFuncHelp const help_lognormdist[] = {
 	{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("LOGNORMDIST(3,1,2) equals 0.519662338.") },
 	{ GNM_FUNC_HELP_SEEALSO, "NORMDIST"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Log-normal_distribution") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:LogNormalDistribution.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -418,6 +436,8 @@ static GnmFuncHelp const help_loginv[] = {
 	{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("LOGINV(0.5,2,3) equals 7.389056099.")},
 	{ GNM_FUNC_HELP_SEEALSO, ("EXP,LN,LOG,LOG10,LOGNORMDIST")},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Log-normal_distribution") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:LogNormalDistribution.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -495,6 +515,8 @@ static GnmFuncHelp const help_harmean[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then HARMEAN(A1:A5) equals 19.529814427.") },
 	{ GNM_FUNC_HELP_SEEALSO, "AVERAGE,GEOMEAN,MEDIAN,MODE,TRIMMEAN"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Harmonic_mean") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:HarmonicMean.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -520,6 +542,8 @@ static GnmFuncHelp const help_geomean[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then GEOMEAN(A1:A5) equals 21.279182482.") },
 	{ GNM_FUNC_HELP_SEEALSO, "AVERAGE,HARMEAN,MEDIAN,MODE,TRIMMEAN"},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Geometric_mean") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:GeometricMean.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
@@ -614,6 +638,8 @@ static GnmFuncHelp const help_average[] = {
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1.") },
 	{ GNM_FUNC_HELP_EXAMPLES, F_("Then AVERAGE(A1:A5) equals 23.2.")},
 	{ GNM_FUNC_HELP_SEEALSO, ("SUM, COUNT")},
+	{ GNM_FUNC_HELP_EXTREF, F_("wiki:en:Arithmetic_mean") },
+	{ GNM_FUNC_HELP_EXTREF, F_("wolfram:ArithmeticMean.html") },
 	{ GNM_FUNC_HELP_END }
 };
 
diff --git a/src/func.c b/src/func.c
index 8f4fee6..35c46a9 100644
--- a/src/func.c
+++ b/src/func.c
@@ -210,8 +210,8 @@ dump_externals (GPtrArray *defs, FILE *out)
 	fprintf (out, "<!--#include virtual=\"header-begin.shtml\" -->");
 	fprintf (out, "<link rel=\"stylesheet\" href=\"style/index.css\" type=\"text/css\"/>");
 	fprintf (out, "<!--#include virtual=\"header-end.shtml\" -->");
-	fprintf (out, "<!--set var=\"wolfram\" value=\"none\" -->");
-	fprintf (out, "<!--set var=\"wiki\" value=\"none\" -->");
+	fprintf (out, "<!--#set var=\"wolfram\" value=\"none\" -->");
+	fprintf (out, "<!--#set var=\"wiki\" value=\"none\" -->");
 	fprintf (out, "<!--\n\n-->");
 
 	for (ui = 0; ui < defs->len; ui++) {
@@ -249,12 +249,15 @@ dump_externals (GPtrArray *defs, FILE *out)
 			fprintf (out, "<!--#endif\n\n-->");
 	}
 
+	fprintf (out, "<div class=\"floatflush\">\n");
+	fprintf (out, "<h1>Online Documentation for \"<!--#echo var=\"QUERY_STRING\" -->\"</h1>\n");
 	fprintf (out, "<ul>");
 	fprintf (out, "<!--#if expr=\"${wolfram} != none\"-->");
 	fprintf (out, "<li><a href=\"http://mathworld.wolfram.com/<!--#echo var=\"wolfram\" -->\">Wolfram Mathworld entry</a>.</li><!--#endif-->");
 	fprintf (out, "<!--#if expr=\"${wiki} != none\"--><li><a href=\"http://<!--#echo var=\"wiki_lang\" -->.wikipedia.org/wiki/<!--#echo var=\"wiki\" -->\">Wikipedia entry</a>.</li><!--#endif-->");
 	fprintf (out, "<li><a href=\"http://www.google.com/#q=<!--#echo var=\"QUERY_STRING_UNESCAPED\" -->\">Google Search</a>.</li>");
 	fprintf (out, "</ul>");
+	fprintf (out, "</div>\n");
 
 	fprintf (out, "<!--#include virtual=\"footer.shtml\" -->\n");
 }
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]