[gnumeric] add more synonyms for xls & xlsx export/import
- From: Andreas J. Guelzow <guelzow src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] add more synonyms for xls & xlsx export/import
- Date: Sat, 22 Jun 2013 04:03:53 +0000 (UTC)
commit 42d5481ee385d1cd5f4e7351afda894ec9d516f8
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date: Fri Jun 21 22:02:12 2013 -0600
add more synonyms for xls & xlsx export/import
2013-06-21 Andreas J. Guelzow <aguelzow pyrshep ca>
* ms-formula-read.c (ms-formula-read.c): add more
synonyms
* xlsx-utils.c (xlsx_conventions_new): add more
synonyms
2013-06-21 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c (help_tinv): correct description
plugins/excel/ChangeLog | 7 +++++++
plugins/excel/ms-formula-read.c | 7 +++++++
plugins/excel/xlsx-utils.c | 8 +++++++-
plugins/fn-stat/ChangeLog | 4 ++++
plugins/fn-stat/functions.c | 8 +++++---
5 files changed, 30 insertions(+), 4 deletions(-)
---
diff --git a/plugins/excel/ChangeLog b/plugins/excel/ChangeLog
index dcf27ba..fda6df5 100644
--- a/plugins/excel/ChangeLog
+++ b/plugins/excel/ChangeLog
@@ -1,5 +1,12 @@
2013-06-21 Andreas J. Guelzow <aguelzow pyrshep ca>
+ * ms-formula-read.c (ms-formula-read.c): add more
+ synonyms
+ * xlsx-utils.c (xlsx_conventions_new): add more
+ synonyms
+
+2013-06-21 Andreas J. Guelzow <aguelzow pyrshep ca>
+
* ms-formula-read.c (ms-formula-read.c): add
"f.inv" --> "r.qf"
* xlsx-utils.c (xlsx_func_finv_output_handler): new
diff --git a/plugins/excel/ms-formula-read.c b/plugins/excel/ms-formula-read.c
index 23a4145..824db31 100644
--- a/plugins/excel/ms-formula-read.c
+++ b/plugins/excel/ms-formula-read.c
@@ -493,16 +493,23 @@ xl2010_synonyms (const char *name)
{ "f.test", "ftest" },
{ "gamma.dist", "gammadist" },
{ "gamma.inv", "gammainv" },
+ { "lognorm.inv", "loginv" },
{ "mode.sngl", "mode" },
+ { "norm.dist", "normdist" },
+ { "norm.inv", "norminv" },
+ { "norm.s.inv", "normsinv" },
{ "percentile.inc", "percentile" },
{ "percentrank.inc", "percentrank" },
+ { "poisson.dist", "poisson" },
{ "quartile.inc", "quartile" },
{ "rank.eq", "rank" },
{ "stdev.p", "stdevp" },
{ "stdev.s", "stdev" },
+ { "t.inv.2t", "tinv" },
{ "t.test", "ttest" },
{ "var.p", "varp" },
{ "var.s", "var" },
+ { "weibull.dist", "weibull" },
{ "z.test", "ztest" }
};
unsigned ui;
diff --git a/plugins/excel/xlsx-utils.c b/plugins/excel/xlsx-utils.c
index 9c379ec..d71e2ee 100644
--- a/plugins/excel/xlsx-utils.c
+++ b/plugins/excel/xlsx-utils.c
@@ -296,16 +296,22 @@ xlsx_conventions_new (gboolean output)
{ "F.TEST", "FTEST" },
{ "GAMMA.DIST", "GAMMADIST" },
{ "GAMMA.INV", "GAMMAINV" },
- { "MODE.SNGL", "MODE" },
+ { "LOGNORM.INV", "LOGINV" },
+ { "NORM.DIST", "NORMDIST" },
+ { "NORM.INV", "NORMINV" },
+ { "NORM.S.INV", "NORMSINV" },
{ "PERCENTILE.INC", "PERCENTILE" },
{ "PERCENTRANK.INC", "PERCENTRANK" },
+ { "POISSON.DIST", "POISSON" },
{ "QUARTILE.INC", "QUARTILE" },
{ "RANK.EQ", "RANK" },
{ "STDEV.P", "STDEVP" },
{ "STDEV.S", "STDEV" },
{ "T.TEST", "TTEST" },
+ { "T.INV.2T", "TINV" },
{ "VAR.P", "VARP" },
{ "VAR.S", "VAR" },
+ { "WEIBULL.DIST", "WEIBULL" },
{ "Z.TEST", "ZTEST" },
{ NULL, NULL }
};
diff --git a/plugins/fn-stat/ChangeLog b/plugins/fn-stat/ChangeLog
index 5224805..7c8475c 100644
--- a/plugins/fn-stat/ChangeLog
+++ b/plugins/fn-stat/ChangeLog
@@ -1,3 +1,7 @@
+2013-06-21 Andreas J. Guelzow <aguelzow pyrshep ca>
+
+ * functions.c (help_tinv): correct description
+
2013-05-29 Andreas J. Guelzow <aguelzow pyrshep ca>
* functions.c (help_snorm_dist_range): add note and seealso.
diff --git a/plugins/fn-stat/functions.c b/plugins/fn-stat/functions.c
index 9a17c53..11ec3ab 100644
--- a/plugins/fn-stat/functions.c
+++ b/plugins/fn-stat/functions.c
@@ -1285,10 +1285,12 @@ gnumeric_tdist (GnmFuncEvalInfo *ei, GnmValue const * const *argv)
/***************************************************************************/
static GnmFuncHelp const help_tinv[] = {
- { GNM_FUNC_HELP_NAME, F_("TINV:inverse of the survival function of the Student t-distribution")},
- { GNM_FUNC_HELP_ARG, F_("p:probability")},
+ { GNM_FUNC_HELP_NAME, F_("TINV:two tailed inverse of the Student t-distribution")},
+ { GNM_FUNC_HELP_ARG, F_("p:probability in both tails")},
{ GNM_FUNC_HELP_ARG, F_("dof:number of degrees of freedom")},
- { GNM_FUNC_HELP_DESCRIPTION, F_("The survival function is 1 minus the cumulative distribution
function.") },
+ { GNM_FUNC_HELP_DESCRIPTION, F_("This functions returns the non-negative value x such that the "
+ "area under the Student t density with @{dof} degrees of freedom "
+ "to the right of x is @{p}/2.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{p} < 0 or @{p} > 1 or @{dof} < 1 this function returns a #NUM!
error.")},
{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
{ GNM_FUNC_HELP_NOTE, F_("The parameterization of this function is different from "
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]