[gnumeric] Export r.qbeta, r.qgamma, r.qlognorm, r.qt to xlsx



commit c92c57b74f1f5b93220409911cda1ca2db560b1e
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Wed Jun 26 08:03:38 2013 -0600

    Export r.qbeta, r.qgamma, r.qlognorm, r.qt to xlsx
    
    2013-06-26  Andreas J. Guelzow <aguelzow pyrshep ca>
    
        * xlsx-utils.c (xlsx_func_betainv_output_handler): new
        (xlsx_func_gammainv_output_handler): new
        (xlsx_func_lognorminv_output_handler): new
        (xlsx_func_tinv_output_handler): new
        (xlsx_conventions_new): connect the above

 plugins/excel/ChangeLog    |    8 ++++++++
 plugins/excel/xlsx-utils.c |   30 +++++++++++++++++++++++++++++-
 2 files changed, 37 insertions(+), 1 deletions(-)
---
diff --git a/plugins/excel/ChangeLog b/plugins/excel/ChangeLog
index 4d68bba..665c569 100644
--- a/plugins/excel/ChangeLog
+++ b/plugins/excel/ChangeLog
@@ -1,3 +1,11 @@
+2013-06-26  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+       * xlsx-utils.c (xlsx_func_betainv_output_handler): new
+       (xlsx_func_gammainv_output_handler): new
+       (xlsx_func_lognorminv_output_handler): new
+       (xlsx_func_tinv_output_handler): new
+       (xlsx_conventions_new): connect the above
+
 2013-06-25  Andreas J. Guelzow <aguelzow pyrshep ca>
 
        * xlsx-utils.c (xlsx_write_r_q_func): add argument and change
diff --git a/plugins/excel/xlsx-utils.c b/plugins/excel/xlsx-utils.c
index eefdacd..baba44e 100644
--- a/plugins/excel/xlsx-utils.c
+++ b/plugins/excel/xlsx-utils.c
@@ -374,6 +374,30 @@ xlsx_func_binominv_output_handler (GnmConventionsOut *out, GnmExprFunction const
 }
 
 static gboolean
+xlsx_func_betainv_output_handler (GnmConventionsOut *out, GnmExprFunction const *func)
+{
+       return xlsx_func_r_q_output_handler (out, func, 2, 0, "_xlfn.BETA.INV", NULL);
+}
+
+static gboolean
+xlsx_func_gammainv_output_handler (GnmConventionsOut *out, GnmExprFunction const *func)
+{
+       return xlsx_func_r_q_output_handler (out, func, 2, 0, "_xlfn.GAMMA.INV", NULL);
+}
+
+static gboolean
+xlsx_func_lognorminv_output_handler (GnmConventionsOut *out, GnmExprFunction const *func)
+{
+       return xlsx_func_r_q_output_handler (out, func, 2, 0, "_xlfn.LOGNORM.INV", NULL);
+}
+
+static gboolean
+xlsx_func_tinv_output_handler (GnmConventionsOut *out, GnmExprFunction const *func)
+{
+       return xlsx_func_r_q_output_handler (out, func, 1, 0, "_xlfn.T.INV", NULL);
+}
+
+static gboolean
 xlsx_func_floor_output_handler (GnmConventionsOut *out, GnmExprFunction const *func)
 /* FLOOR(a) --> ROUNDDOWN(a,0) */
 {
@@ -404,10 +428,14 @@ xlsx_conventions_new (gboolean output)
                char const *gnm_name;
                gpointer handler;
        } const xlfn_func_output_handlers[] = {
+               {"R.QBETA", xlsx_func_betainv_output_handler},
                {"R.QBINOM", xlsx_func_binominv_output_handler},
                {"R.QCHISQ", xlsx_func_chisqinv_output_handler},
-               {"R.QNORM", xlsx_func_norminv_output_handler},
                {"R.QF", xlsx_func_finv_output_handler},
+               {"R.QGAMMA", xlsx_func_gammainv_output_handler},
+               {"R.QLNORM", xlsx_func_lognorminv_output_handler},
+               {"R.QNORM", xlsx_func_norminv_output_handler},
+               {"R.QT", xlsx_func_tinv_output_handler},
                {"FLOOR", xlsx_func_floor_output_handler},
                {NULL, NULL}
        };


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]