[gnumeric] add more synonyms for xls & xlsx export/import



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]