[gnumeric] Some function name adjustments in ODF import/export

From: Andreas J. Guelzow <guelzow src gnome org>
To: svn-commits-list gnome org
Subject: [gnumeric] Some function name adjustments in ODF import/export
Date: Wed, 17 Jun 2009 18:03:22 -0400 (EDT)
commit ffedc607f34b9321bace86c72015999498d17e71
Author: Andreas J. Guelzow <aguelzow pyrshep ca>
Date:   Wed Jun 17 16:02:38 2009 -0600

    Some function name adjustments in ODF import/export
    
    2009-06-17 Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* openoffice-read.c (oo_func_map_in): perform some function name
    	  translation
    	* openoffice-write.c (odf_expr_func_handler): perform some function
    	  name translation

 plugins/openoffice/ChangeLog          |    7 +
 plugins/openoffice/openoffice-read.c  |  435 ++++++++++++++++++++++++
 plugins/openoffice/openoffice-write.c |  585 ++++++++++++++++++++++++++++++++-
 3 files changed, 1025 insertions(+), 2 deletions(-)
---
diff --git a/plugins/openoffice/ChangeLog b/plugins/openoffice/ChangeLog
index 64aa31a..e5eab35 100644
--- a/plugins/openoffice/ChangeLog
+++ b/plugins/openoffice/ChangeLog
@@ -1,5 +1,12 @@
 2009-06-17 Andreas J. Guelzow <aguelzow pyrshep ca>
 
+	* openoffice-read.c (oo_func_map_in): perform some function name 
+	  translation
+	* openoffice-write.c (odf_expr_func_handler): perform some function 
+	  name translation
+
+2009-06-17 Andreas J. Guelzow <aguelzow pyrshep ca>
+
 	* openoffice-read.c (oo_func_map_in): handle ORG.GNUMERIC. prefix
 	* openoffice-write.c (odf_expr_func_handler): new
 	(odf_expr_conventions_new): hook up odf_expr_func_handler
diff --git a/plugins/openoffice/openoffice-read.c b/plugins/openoffice/openoffice-read.c
index 73863d7..86996ad 100644
--- a/plugins/openoffice/openoffice-read.c
+++ b/plugins/openoffice/openoffice-read.c
@@ -3604,9 +3604,444 @@ oo_func_map_in (GnmConventions const *convs, Workbook *scope,
 		char const *oo_name;
 		char const *gnm_name;
 	} const sc_func_renames[] = {
+/* The next functions are or were used by OpenOffice but are not in ODF OpenFormula draft 20090508 */
+
 		{ "INDIRECT_XL",	"INDIRECT" },
 		{ "ADDRESS_XL",		"ADDRESS" },
 		{ "ERRORTYPE",		"ERROR.TYPE" },
+
+/* The following is a list of the functions defined in ODF OpenFormula draft 20090508 */
+/* where we do not have a function with the same name                                 */
+
+/* { "ACOTH","ACOTH" }, */
+/* { "ARABIC","ARABIC" }, */
+/* { "AVERAGEIFS","AVERAGEIFS" }, */
+/* { "B","B" }, */
+/* { "CHISQDIST","CHISQDIST" }, */
+/* { "CHISQINV","CHISQINV" }, */
+/* { "COMBINA","COMBINA" }, */
+/* { "COTH","COTH" }, */
+/* { "COUNTIFS","COUNTIFS" }, */
+/* { "CSC","CSC" }, */
+/* { "CSCH","CSCH" }, */
+/* { "DAYS","DAYS" }, */
+/* { "DDE","DDE" }, */
+/* { "FINDB","FINDB" }, */
+/* { "FORMULA","FORMULA" }, */
+/* { "GAMMA","GAMMA" }, */
+/* { "GAUSS","GAUSS" }, */
+/* { "IFNA","IFNA" }, */
+/* { "ISFORMULA","ISFORMULA" }, */
+/* { "JIS","JIS" }, */
+/* { "MIDB","MIDB" }, */
+/* { "MULTIPLE.OPERATIONS","MULTIPLE.OPERATIONS" }, */
+/* { "MUNIT","MUNIT" }, */
+/* { "NUMBERVALUE","NUMBERVALUE" }, */
+/* { "PDURATION","PDURATION" }, */
+/* { "PERMUTATIONA","PERMUTATIONA" }, */
+/* { "PHI","PHI" }, */
+/* { "REPLACEB","REPLACEB" }, */
+/* { "RIGHTB","RIGHTB" }, */
+/* { "RRI","RRI" }, */
+/* { "SEARCHB","SEARCHB" }, */
+/* { "SHEET","SHEET" }, */
+/* { "SHEETS","SHEETS" }, */
+/* { "SUMIFS","SUMIFS" }, */
+		{ "USDOLLAR","DOLLAR" },
+
+/* The following is a complete list of the functions defined in ODF OpenFormula draft 20090508 */
+/* We should determine whether any mapping is needed. */
+
+		{ "LEGACY.CHIDIST","CHIDIST" },
+		{ "LEGACY.CHIINV","CHIINV" },
+		{ "LEGACY.CHITEST","CHITEST" },
+		{ "LEGACY.FDIST","FDIST" },
+		{ "LEGACY.FINV","FINV" },
+		{ "LEGACY.NORMSDIST","NORMSDIST" },
+		{ "LEGACY.NORMSINV","NORMSINV" },
+
+/* { "ABS","ABS" }, */
+/* { "ACCRINT","ACCRINT" }, */
+/* { "ACCRINTM","ACCRINTM" }, */
+/* { "ACOS","ACOS" }, */
+/* { "ACOSH","ACOSH" }, */
+/* { "ACOT","ACOT" }, */
+/* { "ACOTH","ACOTH" }, */
+/* { "ADDRESS","ADDRESS" }, */
+/* { "AMORDEGRC","AMORDEGRC" }, */
+/* { "AMORLINC","AMORLINC" }, */
+/* { "AND","AND" }, */
+/* { "ARABIC","ARABIC" }, */
+/* { "AREAS","AREAS" }, */
+/* { "ASC","ASC" }, */
+/* { "ASIN","ASIN" }, */
+/* { "ASINH","ASINH" }, */
+/* { "ATAN","ATAN" }, */
+/* { "ATAN2","ATAN2" }, */
+/* { "ATANH","ATANH" }, */
+/* { "AVEDEV","AVEDEV" }, */
+/* { "AVERAGE","AVERAGE" }, */
+/* { "AVERAGEA","AVERAGEA" }, */
+/* { "AVERAGEIFS","AVERAGEIFS" }, */
+/* { "B","B" }, */
+/* { "BASE","BASE" }, */
+/* { "BESSELI","BESSELI" }, */
+/* { "BESSELJ","BESSELJ" }, */
+/* { "BESSELK","BESSELK" }, */
+/* { "BESSELY","BESSELY" }, */
+/* { "BETADIST","BETADIST" }, */
+/* { "BETAINV","BETAINV" }, */
+/* { "BIN2DEC","BIN2DEC" }, */
+/* { "BIN2HEX","BIN2HEX" }, */
+/* { "BIN2OCT","BIN2OCT" }, */
+/* { "BINOMDIST","BINOMDIST" }, */
+/* { "BITAND","BITAND" }, */
+/* { "BITLSHIFT","BITLSHIFT" }, */
+/* { "BITOR","BITOR" }, */
+/* { "BITRSHIFT","BITRSHIFT" }, */
+/* { "BITXOR","BITXOR" }, */
+/* { "CEILING","CEILING" }, */
+/* { "CHAR","CHAR" }, */
+/* { "CHISQDIST","CHISQDIST" }, */
+/* { "CHISQINV","CHISQINV" }, */
+/* { "CHOOSE","CHOOSE" }, */
+/* { "CLEAN","CLEAN" }, */
+/* { "CODE","CODE" }, */
+/* { "COLUMN","COLUMN" }, */
+/* { "COLUMNS","COLUMNS" }, */
+/* { "COMBIN","COMBIN" }, */
+/* { "COMBINA","COMBINA" }, */
+/* { "COMPLEX","COMPLEX" }, */
+/* { "CONCATENATE","CONCATENATE" }, */
+/* { "CONFIDENCE","CONFIDENCE" }, */
+/* { "CONVERT","CONVERT" }, */
+/* { "CORREL","CORREL" }, */
+/* { "COS","COS" }, */
+/* { "COSH","COSH" }, */
+/* { "COT","COT" }, */
+/* { "COTH","COTH" }, */
+/* { "COUNT","COUNT" }, */
+/* { "COUNTA","COUNTA" }, */
+/* { "COUNTBLANK","COUNTBLANK" }, */
+/* { "COUNTIF","COUNTIF" }, */
+/* { "COUNTIFS","COUNTIFS" }, */
+/* { "COUPDAYBS","COUPDAYBS" }, */
+/* { "COUPDAYS","COUPDAYS" }, */
+/* { "COUPDAYSNC","COUPDAYSNC" }, */
+/* { "COUPNCD","COUPNCD" }, */
+/* { "COUPNUM","COUPNUM" }, */
+/* { "COUPPCD","COUPPCD" }, */
+/* { "COVAR","COVAR" }, */
+/* { "CRITBINOM","CRITBINOM" }, */
+/* { "CSC","CSC" }, */
+/* { "CSC","CSC" }, */
+/* { "CSCH","CSCH" }, */
+/* { "CUMIPMT","CUMIPMT" }, */
+/* { "CUMPRINC","CUMPRINC" }, */
+/* { "DATE","DATE" }, */
+/* { "DATEDIF","DATEDIF" }, */
+/* { "DATEVALUE","DATEVALUE" }, */
+/* { "DAVERAGE","DAVERAGE" }, */
+/* { "DAY","DAY" }, */
+/* { "DAYS","DAYS" }, */
+/* { "DAYS360","DAYS360" }, */
+/* { "DB","DB" }, */
+/* { "DCOUNT","DCOUNT" }, */
+/* { "DCOUNTA","DCOUNTA" }, */
+/* { "DDB","DDB" }, */
+/* { "DDE","DDE" }, */
+/* { "DEC2BIN","DEC2BIN" }, */
+/* { "DEC2HEX","DEC2HEX" }, */
+/* { "DEC2OCT","DEC2OCT" }, */
+/* { "DECIMAL","DECIMAL" }, */
+/* { "DEGREES","DEGREES" }, */
+/* { "DELTA","DELTA" }, */
+/* { "DEVSQ","DEVSQ" }, */
+/* { "DGET","DGET" }, */
+/* { "DISC","DISC" }, */
+/* { "DMAX","DMAX" }, */
+/* { "DMIN","DMIN" }, */
+/* { "DOLLARDE","DOLLARDE" }, */
+/* { "DOLLARFR","DOLLARFR" }, */
+/* { "DPRODUCT","DPRODUCT" }, */
+/* { "DSTDEV","DSTDEV" }, */
+/* { "DSTDEVP","DSTDEVP" }, */
+/* { "DSUM","DSUM" }, */
+/* { "DURATION","DURATION" }, */
+/* { "DVAR","DVAR" }, */
+/* { "DVARP","DVARP" }, */
+/* { "EDATE","EDATE" }, */
+/* { "EFFECT","EFFECT" }, */
+/* { "EOMONTH","EOMONTH" }, */
+/* { "ERF","ERF" }, */
+/* { "ERFC","ERFC" }, */
+/* { "ERROR.TYPE","ERROR.TYPE" }, */
+/* { "EUROCONVERT","EUROCONVERT" }, */
+/* { "EVEN","EVEN" }, */
+/* { "EXACT","EXACT" }, */
+/* { "EXP","EXP" }, */
+/* { "EXPONDIST","EXPONDIST" }, */
+/* { "FACT","FACT" }, */
+/* { "FACTDOUBLE","FACTDOUBLE" }, */
+/* { "FALSE","FALSE" }, */
+/* { "FDIST","FDIST" }, */
+/* { "FIND","FIND" }, */
+/* { "FINDB","FINDB" }, */
+/* { "FINV","FINV" }, */
+/* { "FISHER","FISHER" }, */
+/* { "FISHERINV","FISHERINV" }, */
+/* { "FIXED","FIXED" }, */
+/* { "FLOOR","FLOOR" }, */
+/* { "FORECAST","FORECAST" }, */
+/* { "FORMULA","FORMULA" }, */
+/* { "FREQUENCY","FREQUENCY" }, */
+/* { "FTEST","FTEST" }, */
+/* { "FV","FV" }, */
+/* { "FVSCHEDULE","FVSCHEDULE" }, */
+/* { "GAMMA","GAMMA" }, */
+/* { "GAMMADIST","GAMMADIST" }, */
+/* { "GAMMAINV","GAMMAINV" }, */
+/* { "GAMMALN","GAMMALN" }, */
+/* { "GAUSS","GAUSS" }, */
+/* { "GCD","GCD" }, */
+/* { "GEOMEAN","GEOMEAN" }, */
+/* { "GESTEP","GESTEP" }, */
+/* { "GETPIVOTDATA","GETPIVOTDATA" }, */
+/* { "GROWTH","GROWTH" }, */
+/* { "HARMEAN","HARMEAN" }, */
+/* { "HEX2BIN","HEX2BIN" }, */
+/* { "HEX2DEC","HEX2DEC" }, */
+/* { "HEX2OCT","HEX2OCT" }, */
+/* { "HLOOKUP","HLOOKUP" }, */
+/* { "HOUR","HOUR" }, */
+/* { "HYPERLINK","HYPERLINK" }, */
+/* { "HYPGEOMDIST","HYPGEOMDIST" }, */
+/* { "IF","IF" }, */
+/* { "IFERROR","IFERROR" }, */
+/* { "IFNA","IFNA" }, */
+/* { "IMABS","IMABS" }, */
+/* { "IMAGINARY","IMAGINARY" }, */
+/* { "IMARGUMENT","IMARGUMENT" }, */
+/* { "IMCONJUGATE","IMCONJUGATE" }, */
+/* { "IMCOS","IMCOS" }, */
+/* { "IMCOT","IMCOT" }, */
+/* { "IMCSC","IMCSC" }, */
+/* { "IMCSCH","IMCSCH" }, */
+/* { "IMDIV","IMDIV" }, */
+/* { "IMEXP","IMEXP" }, */
+/* { "IMLN","IMLN" }, */
+/* { "IMLOG10","IMLOG10" }, */
+/* { "IMLOG2","IMLOG2" }, */
+/* { "IMPOWER","IMPOWER" }, */
+/* { "IMPRODUCT","IMPRODUCT" }, */
+/* { "IMREAL","IMREAL" }, */
+/* { "IMSEC","IMSEC" }, */
+/* { "IMSECH","IMSECH" }, */
+/* { "IMSIN","IMSIN" }, */
+/* { "IMSQRT","IMSQRT" }, */
+/* { "IMSUB","IMSUB" }, */
+/* { "IMSUM","IMSUM" }, */
+/* { "IMTAN","IMTAN" }, */
+/* { "INDEX","INDEX" }, */
+/* { "INDIRECT","INDIRECT" }, */
+/* { "INFO","INFO" }, */
+/* { "INT","INT" }, */
+/* { "INTERCEPT","INTERCEPT" }, */
+/* { "INTRATE","INTRATE" }, */
+/* { "IPMT","IPMT" }, */
+/* { "IRR","IRR" }, */
+/* { "ISBLANK","ISBLANK" }, */
+/* { "ISERR","ISERR" }, */
+/* { "ISERROR","ISERROR" }, */
+/* { "ISEVEN","ISEVEN" }, */
+/* { "ISFORMULA","ISFORMULA" }, */
+/* { "ISLOGICAL","ISLOGICAL" }, */
+/* { "ISNA","ISNA" }, */
+/* { "ISNONTEXT","ISNONTEXT" }, */
+/* { "ISNUMBER","ISNUMBER" }, */
+/* { "ISODD","ISODD" }, */
+/* { "ISOWEEKNUM","ISOWEEKNUM" }, */
+/* { "ISPMT","ISPMT" }, */
+/* { "ISREF","ISREF" }, */
+/* { "ISTEXT","ISTEXT" }, */
+/* { "JIS","JIS" }, */
+/* { "KURT","KURT" }, */
+/* { "LARGE","LARGE" }, */
+/* { "LCM","LCM" }, */
+/* { "LEFT","LEFT" }, */
+/* { "LEFTB","LEFTB" }, */
+/* { "LEN","LEN" }, */
+/* { "LENB","LENB" }, */
+/* { "LINEST","LINEST" }, */
+/* { "LN","LN" }, */
+/* { "LOG","LOG" }, */
+/* { "LOG10","LOG10" }, */
+/* { "LOGEST","LOGEST" }, */
+/* { "LOGINV","LOGINV" }, */
+/* { "LOGNORMDIST","LOGNORMDIST" }, */
+/* { "LOOKUP","LOOKUP" }, */
+/* { "LOWER","LOWER" }, */
+/* { "MATCH","MATCH" }, */
+/* { "MAX","MAX" }, */
+/* { "MAXA","MAXA" }, */
+/* { "MDETERM","MDETERM" }, */
+/* { "MDURATION","MDURATION" }, */
+/* { "MEDIAN","MEDIAN" }, */
+/* { "MID","MID" }, */
+/* { "MIDB","MIDB" }, */
+/* { "MIN","MIN" }, */
+/* { "MINA","MINA" }, */
+/* { "MINUTE","MINUTE" }, */
+/* { "MINVERSE","MINVERSE" }, */
+/* { "MIRR","MIRR" }, */
+/* { "MMULT","MMULT" }, */
+/* { "MOD","MOD" }, */
+/* { "MODE","MODE" }, */
+/* { "MONTH","MONTH" }, */
+/* { "MROUND","MROUND" }, */
+/* { "MULTINOMIAL","MULTINOMIAL" }, */
+/* { "MULTIPLE.OPERATIONS","MULTIPLE.OPERATIONS" }, */
+/* { "MUNIT","MUNIT" }, */
+/* { "N","N" }, */
+/* { "NA","NA" }, */
+/* { "NEGBINOMDIST","NEGBINOMDIST" }, */
+/* { "NETWORKDAYS","NETWORKDAYS" }, */
+/* { "NOMINAL","NOMINAL" }, */
+/* { "NORMDIST","NORMDIST" }, */
+/* { "NORMINV","NORMINV" }, */
+/* { "NOT","NOT" }, */
+/* { "NOW","NOW" }, */
+/* { "NPER","NPER" }, */
+/* { "NPV","NPV" }, */
+/* { "NUMBERVALUE","NUMBERVALUE" }, */
+/* { "OCT2BIN","OCT2BIN" }, */
+/* { "OCT2DEC","OCT2DEC" }, */
+/* { "OCT2HEX","OCT2HEX" }, */
+/* { "ODD","ODD" }, */
+/* { "ODDFPRICE","ODDFPRICE" }, */
+/* { "ODDFYIELD","ODDFYIELD" }, */
+/* { "ODDLPRICE","ODDLPRICE" }, */
+/* { "ODDLYIELD","ODDLYIELD" }, */
+/* { "OFFSET","OFFSET" }, */
+/* { "OR","OR" }, */
+/* { "PDURATION","PDURATION" }, */
+/* { "PEARSON","PEARSON" }, */
+/* { "PERCENTILE","PERCENTILE" }, */
+/* { "PERCENTRANK","PERCENTRANK" }, */
+/* { "PERMUT","PERMUT" }, */
+/* { "PERMUTATIONA","PERMUTATIONA" }, */
+/* { "PHI","PHI" }, */
+/* { "PI","PI" }, */
+/* { "PMT","PMT" }, */
+/* { "POISSON","POISSON" }, */
+/* { "POWER","POWER" }, */
+/* { "PPMT","PPMT" }, */
+/* { "PRICE","PRICE" }, */
+/* { "PRICEDISC","PRICEDISC" }, */
+/* { "PRICEMAT","PRICEMAT" }, */
+/* { "PROB","PROB" }, */
+/* { "PRODUCT","PRODUCT" }, */
+/* { "PROPER","PROPER" }, */
+/* { "PV","PV" }, */
+/* { "QUARTILE","QUARTILE" }, */
+/* { "QUOTIENT","QUOTIENT" }, */
+/* { "RADIANS","RADIANS" }, */
+/* { "RAND","RAND" }, */
+/* { "RANDBETWEEN","RANDBETWEEN" }, */
+/* { "RANK","RANK" }, */
+/* { "RATE","RATE" }, */
+/* { "RECEIVED","RECEIVED" }, */
+/* { "REPLACE","REPLACE" }, */
+/* { "REPLACEB","REPLACEB" }, */
+/* { "REPT","REPT" }, */
+/* { "RIGHT","RIGHT" }, */
+/* { "RIGHTB","RIGHTB" }, */
+/* { "ROMAN","ROMAN" }, */
+/* { "ROUND","ROUND" }, */
+/* { "ROUNDDOWN","ROUNDDOWN" }, */
+/* { "ROUNDUP","ROUNDUP" }, */
+/* { "ROW","ROW" }, */
+/* { "ROWS","ROWS" }, */
+/* { "RRI","RRI" }, */
+/* { "RSQ","RSQ" }, */
+/* { "SEARCH","SEARCH" }, */
+/* { "SEARCHB","SEARCHB" }, */
+/* { "SEC","SEC" }, */
+/* { "SECH","SECH" }, */
+/* { "SECOND","SECOND" }, */
+/* { "SERIESSUM","SERIESSUM" }, */
+/* { "SHEET","SHEET" }, */
+/* { "SHEETS","SHEETS" }, */
+/* { "SIGN","SIGN" }, */
+/* { "SIN","SIN" }, */
+/* { "SINH","SINH" }, */
+/* { "SKEW","SKEW" }, */
+/* { "SKEWP","SKEWP" }, */
+/* { "SLN","SLN" }, */
+/* { "SLOPE","SLOPE" }, */
+/* { "SMALL","SMALL" }, */
+/* { "SQRT","SQRT" }, */
+/* { "SQRTPI","SQRTPI" }, */
+/* { "STANDARDIZE","STANDARDIZE" }, */
+/* { "STDEV","STDEV" }, */
+/* { "STDEVA","STDEVA" }, */
+/* { "STDEVP","STDEVP" }, */
+/* { "STDEVPA","STDEVPA" }, */
+/* { "STEYX","STEYX" }, */
+/* { "SUBSTITUTE","SUBSTITUTE" }, */
+/* { "SUBTOTAL","SUBTOTAL" }, */
+/* { "SUM","SUM" }, */
+/* { "SUMIF","SUMIF" }, */
+/* { "SUMIFS","SUMIFS" }, */
+/* { "SUMPRODUCT","SUMPRODUCT" }, */
+/* { "SUMSQ","SUMSQ" }, */
+/* { "SUMX2MY2","SUMX2MY2" }, */
+/* { "SUMX2PY2","SUMX2PY2" }, */
+/* { "SUMXMY2","SUMXMY2" }, */
+/* { "SYD","SYD" }, */
+/* { "T","T" }, */
+/* { "TAN","TAN" }, */
+/* { "TANH","TANH" }, */
+/* { "TBILLEQ","TBILLEQ" }, */
+/* { "TBILLPRICE","TBILLPRICE" }, */
+/* { "TBILLYIELD","TBILLYIELD" }, */
+/* { "TDIST","TDIST" }, */
+/* { "TEXT","TEXT" }, */
+/* { "TIME","TIME" }, */
+/* { "TIMEVALUE","TIMEVALUE" }, */
+/* { "TINV","TINV" }, */
+/* { "TODAY","TODAY" }, */
+/* { "TRANSPOSE","TRANSPOSE" }, */
+/* { "TREND","TREND" }, */
+/* { "TRIM","TRIM" }, */
+/* { "TRIMMEAN","TRIMMEAN" }, */
+/* { "TRUE","TRUE" }, */
+/* { "TRUNC","TRUNC" }, */
+/* { "TTEST","TTEST" }, */
+/* { "TYPE","TYPE" }, */
+/* { "UNICHAR","UNICHAR" }, */
+/* { "UNICODE","UNICODE" }, */
+/* { "UPPER","UPPER" }, */
+/* { "VALUE","VALUE" }, */
+/* { "VAR","VAR" }, */
+/* { "VARA","VARA" }, */
+/* { "VARP","VARP" }, */
+/* { "VARPA","VARPA" }, */
+/* { "VDB","VDB" }, */
+/* { "VLOOKUP","VLOOKUP" }, */
+/* { "WEEKDAY","WEEKDAY" }, */
+/* { "WEEKNUM","WEEKNUM" }, */
+/* { "WEIBULL","WEIBULL" }, */
+/* { "WORKDAY","WORKDAY" }, */
+/* { "XIRR","XIRR" }, */
+/* { "XNPV","XNPV" }, */
+/* { "XOR","XOR" }, */
+/* { "YEAR","YEAR" }, */
+/* { "YEARFRAC","YEARFRAC" }, */
+/* { "YIELD","YIELD" }, */
+/* { "YIELDDISC","YIELDDISC" }, */
+/* { "YIELDMAT","YIELDMAT" }, */
+/* { "ZTEST","ZTEST" }, */
 		{ NULL, NULL }
 	};
 	static char const OOoAnalysisPrefix[] = "com.sun.star.sheet.addin.Analysis.get";
diff --git a/plugins/openoffice/openoffice-write.c b/plugins/openoffice/openoffice-write.c
index 2d9ad8f..b517ac3 100644
--- a/plugins/openoffice/openoffice-write.c
+++ b/plugins/openoffice/openoffice-write.c
@@ -1270,7 +1270,588 @@ odf_expr_func_handler (GnmConventionsOut *out, GnmExprFunction const *func)
 			char const *odf_name;
 		} const sc_func_renames[] = {
 			{ "CEIL", "CEILING" },
-			{ "SSMEDIAN", "ORG.GNUMERIC.SSMEDIAN" },
+			{ "CHIDIST","LEGACY.CHIDIST" },
+			{ "CHIINV","LEGACY.CHIINV" },
+			{ "CHITEST","LEGACY.CHITEST" },
+			{ "FDIST","LEGACY.FDIST" },
+			{ "FINV","LEGACY.FINV" },
+			{ "NORMSDIST","LEGACY.NORMSDIST" },
+			{ "NORMSINV","LEGACY.NORMSINV" },
+
+/* The following Gnumeric specific functions should be preceded by ORG.GNUMERIC.*/
+
+{ "ATL_LAST","ORG.GNUMERIC.ATL_LAST" },
+{ "BERNOULLI","ORG.GNUMERIC.BERNOULLI" },
+{ "BETA","ORG.GNUMERIC.BETA" },
+{ "BETALN","ORG.GNUMERIC.BETALN" },
+{ "CAUCHY","ORG.GNUMERIC.CAUCHY" },
+{ "COLUMNNUMBER","ORG.GNUMERIC.COLUMNNUMBER" },
+{ "CRONBACH","ORG.GNUMERIC.CRONBACH" },
+{ "CUM_BIV_NORM_DIST","ORG.GNUMERIC.CUM_BIV_NORM_DIST" },
+{ "DATE2UNIX","ORG.GNUMERIC.DATE2UNIX" },
+{ "DAYS360","ORG.GNUMERIC.DAYS360" },
+{ "DIMCIRC","ORG.GNUMERIC.DIMCIRC" },
+{ "ERROR","ORG.GNUMERIC.ERROR" },
+{ "EURO","ORG.GNUMERIC.EURO" },
+{ "EXECSQL","ORG.GNUMERIC.EXECSQL" },
+{ "EXPM1","ORG.GNUMERIC.EXPM1" },
+{ "EXPPOWDIST","ORG.GNUMERIC.EXPPOWDIST" },
+{ "EXPRESSION","ORG.GNUMERIC.EXPRESSION" },
+{ "FIB","ORG.GNUMERIC.FIB" },
+{ "G_DURATION","ORG.GNUMERIC.G_DURATION" },
+{ "GEOMDIST","ORG.GNUMERIC.GEOMDIST" },
+{ "GETENV","ORG.GNUMERIC.GETENV" },
+{ "GET.FORMULA","ORG.GNUMERIC.GET.FORMULA" },
+{ "G_PRODUCT","ORG.GNUMERIC.G_PRODUCT" },
+{ "HYPOT","ORG.GNUMERIC.HYPOT" },
+{ "IMARCCOS","ORG.GNUMERIC.IMARCCOS" },
+{ "IMARCCOSH","ORG.GNUMERIC.IMARCCOSH" },
+{ "IMARCCOT","ORG.GNUMERIC.IMARCCOT" },
+{ "IMARCCOTH","ORG.GNUMERIC.IMARCCOTH" },
+{ "IMARCCSC","ORG.GNUMERIC.IMARCCSC" },
+{ "IMARCCSCH","ORG.GNUMERIC.IMARCCSCH" },
+{ "IMARCSEC","ORG.GNUMERIC.IMARCSEC" },
+{ "IMARCSECH","ORG.GNUMERIC.IMARCSECH" },
+{ "IMARCSIN","ORG.GNUMERIC.IMARCSIN" },
+{ "IMARCSINH","ORG.GNUMERIC.IMARCSINH" },
+{ "IMARCTAN","ORG.GNUMERIC.IMARCTAN" },
+{ "IMARCTANH","ORG.GNUMERIC.IMARCTANH" },
+{ "IMCOSH","ORG.GNUMERIC.IMCOSH" },
+{ "IMCOTH","ORG.GNUMERIC.IMCOTH" },
+{ "IMINV","ORG.GNUMERIC.IMINV" },
+{ "IMNEG","ORG.GNUMERIC.IMNEG" },
+{ "IMSINH","ORG.GNUMERIC.IMSINH" },
+{ "IMTANH","ORG.GNUMERIC.IMTANH" },
+{ "INTERPOLATION","ORG.GNUMERIC.INTERPOLATION" },
+{ "INVSUMINV","ORG.GNUMERIC.INVSUMINV" },
+{ "ISOYEAR","ORG.GNUMERIC.ISOYEAR" },
+{ "ISPRIME","ORG.GNUMERIC.ISPRIME" },
+{ "ITHPRIME","ORG.GNUMERIC.ITHPRIME" },
+{ "KURTP","ORG.GNUMERIC.KURTP" },
+{ "LANDAU","ORG.GNUMERIC.LANDAU" },
+{ "LAPLACE","ORG.GNUMERIC.LAPLACE" },
+{ "LN1P","ORG.GNUMERIC.LN1P" },
+{ "LOG2","ORG.GNUMERIC.LOG2" },
+{ "LOGFIT","ORG.GNUMERIC.LOGFIT" },
+{ "LOGISTIC","ORG.GNUMERIC.LOGISTIC" },
+{ "LOGREG","ORG.GNUMERIC.LOGREG" },
+{ "NT_D","ORG.GNUMERIC.NT_D" },
+{ "NT_MU","ORG.GNUMERIC.NT_MU" },
+{ "NT_PHI","ORG.GNUMERIC.NT_PHI" },
+{ "NT_PI","ORG.GNUMERIC.NT_PI" },
+{ "NT_SIGMA","ORG.GNUMERIC.NT_SIGMA" },
+{ "OFFCAP","ORG.GNUMERIC.OFFCAP" },
+{ "OFFTRAF","ORG.GNUMERIC.OFFTRAF" },
+{ "OPT_2_ASSET_CORRELATION","ORG.GNUMERIC.OPT_2_ASSET_CORRELATION" },
+{ "OPT_AMER_EXCHANGE","ORG.GNUMERIC.OPT_AMER_EXCHANGE" },
+{ "OPT_BAW_AMER","ORG.GNUMERIC.OPT_BAW_AMER" },
+{ "OPT_BINOMIAL","ORG.GNUMERIC.OPT_BINOMIAL" },
+{ "OPT_BJER_STENS","ORG.GNUMERIC.OPT_BJER_STENS" },
+{ "OPT_BS","ORG.GNUMERIC.OPT_BS" },
+{ "OPT_BS_CARRYCOST","ORG.GNUMERIC.OPT_BS_CARRYCOST" },
+{ "OPT_BS_DELTA","ORG.GNUMERIC.OPT_BS_DELTA" },
+{ "OPT_BS_GAMMA","ORG.GNUMERIC.OPT_BS_GAMMA" },
+{ "OPT_BS_RHO","ORG.GNUMERIC.OPT_BS_RHO" },
+{ "OPT_BS_THETA","ORG.GNUMERIC.OPT_BS_THETA" },
+{ "OPT_BS_VEGA","ORG.GNUMERIC.OPT_BS_VEGA" },
+{ "OPT_COMPLEX_CHOOSER","ORG.GNUMERIC.OPT_COMPLEX_CHOOSER" },
+{ "OPT_EURO_EXCHANGE","ORG.GNUMERIC.OPT_EURO_EXCHANGE" },
+{ "OPT_EXEC","ORG.GNUMERIC.OPT_EXEC" },
+{ "OPT_EXTENDIBLE_WRITER","ORG.GNUMERIC.OPT_EXTENDIBLE_WRITER" },
+{ "OPT_FIXED_STRK_LKBK","ORG.GNUMERIC.OPT_FIXED_STRK_LKBK" },
+{ "OPT_FLOAT_STRK_LKBK","ORG.GNUMERIC.OPT_FLOAT_STRK_LKBK" },
+{ "OPT_FORWARD_START","ORG.GNUMERIC.OPT_FORWARD_START" },
+{ "OPT_FRENCH","ORG.GNUMERIC.OPT_FRENCH" },
+{ "OPT_GARMAN_KOHLHAGEN","ORG.GNUMERIC.OPT_GARMAN_KOHLHAGEN" },
+{ "OPT_JUMP_DIFF","ORG.GNUMERIC.OPT_JUMP_DIFF" },
+{ "OPT_MILTERSEN_SCHWARTZ","ORG.GNUMERIC.OPT_MILTERSEN_SCHWARTZ" },
+{ "OPT_ON_OPTIONS","ORG.GNUMERIC.OPT_ON_OPTIONS" },
+{ "OPT_RGW","ORG.GNUMERIC.OPT_RGW" },
+{ "OPT_SIMPLE_CHOOSER","ORG.GNUMERIC.OPT_SIMPLE_CHOOSER" },
+{ "OPT_SPREAD_APPROX","ORG.GNUMERIC.OPT_SPREAD_APPROX" },
+{ "OPT_TIME_SWITCH","ORG.GNUMERIC.OPT_TIME_SWITCH" },
+{ "PARETO","ORG.GNUMERIC.PARETO" },
+{ "periodogram","ORG.GNUMERIC.periodogram" },
+{ "PFACTOR","ORG.GNUMERIC.PFACTOR" },
+{ "PROBBLOCK","ORG.GNUMERIC.PROBBLOCK" },
+{ "RANDBERNOULLI","ORG.GNUMERIC.RANDBERNOULLI" },
+{ "RANDBETA","ORG.GNUMERIC.RANDBETA" },
+{ "RANDBINOM","ORG.GNUMERIC.RANDBINOM" },
+{ "RANDCAUCHY","ORG.GNUMERIC.RANDCAUCHY" },
+{ "RANDCHISQ","ORG.GNUMERIC.RANDCHISQ" },
+{ "RANDDISCRETE","ORG.GNUMERIC.RANDDISCRETE" },
+{ "RANDEXP","ORG.GNUMERIC.RANDEXP" },
+{ "RANDEXPPOW","ORG.GNUMERIC.RANDEXPPOW" },
+{ "RANDFDIST","ORG.GNUMERIC.RANDFDIST" },
+{ "RANDGAMMA","ORG.GNUMERIC.RANDGAMMA" },
+{ "RANDGEOM","ORG.GNUMERIC.RANDGEOM" },
+{ "RANDGUMBEL","ORG.GNUMERIC.RANDGUMBEL" },
+{ "RANDHYPERG","ORG.GNUMERIC.RANDHYPERG" },
+{ "RANDLANDAU","ORG.GNUMERIC.RANDLANDAU" },
+{ "RANDLAPLACE","ORG.GNUMERIC.RANDLAPLACE" },
+{ "RANDLEVY","ORG.GNUMERIC.RANDLEVY" },
+{ "RANDLOG","ORG.GNUMERIC.RANDLOG" },
+{ "RANDLOGISTIC","ORG.GNUMERIC.RANDLOGISTIC" },
+{ "RANDLOGNORM","ORG.GNUMERIC.RANDLOGNORM" },
+{ "RANDNEGBINOM","ORG.GNUMERIC.RANDNEGBINOM" },
+{ "RANDNORM","ORG.GNUMERIC.RANDNORM" },
+{ "RANDNORMTAIL","ORG.GNUMERIC.RANDNORMTAIL" },
+{ "RANDPARETO","ORG.GNUMERIC.RANDPARETO" },
+{ "RANDPOISSON","ORG.GNUMERIC.RANDPOISSON" },
+{ "RANDRAYLEIGH","ORG.GNUMERIC.RANDRAYLEIGH" },
+{ "RANDRAYLEIGHTAIL","ORG.GNUMERIC.RANDRAYLEIGHTAIL" },
+{ "RANDTDIST","ORG.GNUMERIC.RANDTDIST" },
+{ "RANDUNIFORM","ORG.GNUMERIC.RANDUNIFORM" },
+{ "RANDWEIBULL","ORG.GNUMERIC.RANDWEIBULL" },
+{ "RAYLEIGH","ORG.GNUMERIC.RAYLEIGH" },
+{ "RAYLEIGHTAIL","ORG.GNUMERIC.RAYLEIGHTAIL" },
+{ "READDBTABLE","ORG.GNUMERIC.READDBTABLE" },
+{ "R.DBETA","ORG.GNUMERIC.R.DBETA" },
+{ "R.DBINOM","ORG.GNUMERIC.R.DBINOM" },
+{ "R.DCAUCHY","ORG.GNUMERIC.R.DCAUCHY" },
+{ "R.DCHISQ","ORG.GNUMERIC.R.DCHISQ" },
+{ "R.DEXP","ORG.GNUMERIC.R.DEXP" },
+{ "R.DF","ORG.GNUMERIC.R.DF" },
+{ "R.DGAMMA","ORG.GNUMERIC.R.DGAMMA" },
+{ "R.DGEOM","ORG.GNUMERIC.R.DGEOM" },
+{ "R.DHYPER","ORG.GNUMERIC.R.DHYPER" },
+{ "R.DLNORM","ORG.GNUMERIC.R.DLNORM" },
+{ "R.DNBINOM","ORG.GNUMERIC.R.DNBINOM" },
+{ "R.DNORM","ORG.GNUMERIC.R.DNORM" },
+{ "R.DPOIS","ORG.GNUMERIC.R.DPOIS" },
+{ "R.DT","ORG.GNUMERIC.R.DT" },
+{ "R.DWEIBULL","ORG.GNUMERIC.R.DWEIBULL" },
+{ "R.PBETA","ORG.GNUMERIC.R.PBETA" },
+{ "R.PBINOM","ORG.GNUMERIC.R.PBINOM" },
+{ "R.PCAUCHY","ORG.GNUMERIC.R.PCAUCHY" },
+{ "R.PCHISQ","ORG.GNUMERIC.R.PCHISQ" },
+{ "R.PEXP","ORG.GNUMERIC.R.PEXP" },
+{ "R.PF","ORG.GNUMERIC.R.PF" },
+{ "R.PGAMMA","ORG.GNUMERIC.R.PGAMMA" },
+{ "R.PGEOM","ORG.GNUMERIC.R.PGEOM" },
+{ "R.PHYPER","ORG.GNUMERIC.R.PHYPER" },
+{ "R.PLNORM","ORG.GNUMERIC.R.PLNORM" },
+{ "R.PNBINOM","ORG.GNUMERIC.R.PNBINOM" },
+{ "R.PNORM","ORG.GNUMERIC.R.PNORM" },
+{ "R.PPOIS","ORG.GNUMERIC.R.PPOIS" },
+{ "R.PT","ORG.GNUMERIC.R.PT" },
+{ "R.PWEIBULL","ORG.GNUMERIC.R.PWEIBULL" },
+{ "R.QBETA","ORG.GNUMERIC.R.QBETA" },
+{ "R.QBINOM","ORG.GNUMERIC.R.QBINOM" },
+{ "R.QCAUCHY","ORG.GNUMERIC.R.QCAUCHY" },
+{ "R.QCHISQ","ORG.GNUMERIC.R.QCHISQ" },
+{ "R.QEXP","ORG.GNUMERIC.R.QEXP" },
+{ "R.QF","ORG.GNUMERIC.R.QF" },
+{ "R.QGAMMA","ORG.GNUMERIC.R.QGAMMA" },
+{ "R.QGEOM","ORG.GNUMERIC.R.QGEOM" },
+{ "R.QHYPER","ORG.GNUMERIC.R.QHYPER" },
+{ "R.QLNORM","ORG.GNUMERIC.R.QLNORM" },
+{ "R.QNBINOM","ORG.GNUMERIC.R.QNBINOM" },
+{ "R.QNORM","ORG.GNUMERIC.R.QNORM" },
+{ "R.QPOIS","ORG.GNUMERIC.R.QPOIS" },
+{ "R.QT","ORG.GNUMERIC.R.QT" },
+{ "R.QWEIBULL","ORG.GNUMERIC.R.QWEIBULL" },
+{ "SIMTABLE","ORG.GNUMERIC.SIMTABLE" },
+{ "SSMEDIAN","ORG.GNUMERIC.SSMEDIAN" },
+{ "SUMA","ORG.GNUMERIC.SUMA" },
+{ "UNIX2DATE","ORG.GNUMERIC.UNIX2DATE" },
+
+
+/* The following is a complete list of the functions defined in ODF OpenFormula draft 20090508 */
+/* We should comment out any functions we do not provide or for which our function of the same name */
+/* behaves differently and should have the Gnumeric prefix. */
+
+/* { "ABS","ABS" }, */
+/* { "ACCRINT","ACCRINT" }, */
+/* { "ACCRINTM","ACCRINTM" }, */
+/* { "ACOS","ACOS" }, */
+/* { "ACOSH","ACOSH" }, */
+/* { "ACOT","ACOT" }, */
+/* /\* { "ACOTH","ACOTH" }, *\/ */
+/* { "ADDRESS","ADDRESS" }, */
+/* { "AMORDEGRC","AMORDEGRC" }, */
+/* { "AMORLINC","AMORLINC" }, */
+/* { "AND","AND" }, */
+/* /\* { "ARABIC","ARABIC" }, *\/ */
+/* { "AREAS","AREAS" }, */
+/* { "ASC","ASC" }, */
+/* { "ASIN","ASIN" }, */
+/* { "ASINH","ASINH" }, */
+/* { "ATAN","ATAN" }, */
+/* { "ATAN2","ATAN2" }, */
+/* { "ATANH","ATANH" }, */
+/* { "AVEDEV","AVEDEV" }, */
+/* { "AVERAGE","AVERAGE" }, */
+/* { "AVERAGEA","AVERAGEA" }, */
+/* /\* { "AVERAGEIFS","AVERAGEIFS" }, *\/ */
+/* /\* { "B","B" }, *\/ */
+/* { "BASE","BASE" }, */
+/* { "BESSELI","BESSELI" }, */
+/* { "BESSELJ","BESSELJ" }, */
+/* { "BESSELK","BESSELK" }, */
+/* { "BESSELY","BESSELY" }, */
+/* { "BETADIST","BETADIST" }, */
+/* { "BETAINV","BETAINV" }, */
+/* { "BIN2DEC","BIN2DEC" }, */
+/* { "BIN2HEX","BIN2HEX" }, */
+/* { "BIN2OCT","BIN2OCT" }, */
+/* { "BINOMDIST","BINOMDIST" }, */
+/* { "BITAND","BITAND" }, */
+/* { "BITLSHIFT","BITLSHIFT" }, */
+/* { "BITOR","BITOR" }, */
+/* { "BITRSHIFT","BITRSHIFT" }, */
+/* { "BITXOR","BITXOR" }, */
+/* { "CEILING","CEILING" }, */
+/* { "CELL","CELL" }, */
+/* { "CHAR","CHAR" }, */
+/* /\* { "CHISQDIST","CHISQDIST" }, *\/ */
+/* /\* { "CHISQINV","CHISQINV" }, *\/ */
+/* { "CHOOSE","CHOOSE" }, */
+/* { "CLEAN","CLEAN" }, */
+/* { "CODE","CODE" }, */
+/* { "COLUMN","COLUMN" }, */
+/* { "COLUMNS","COLUMNS" }, */
+/* { "COMBIN","COMBIN" }, */
+/* /\* { "COMBINA","COMBINA" }, *\/ */
+/* { "COMPLEX","COMPLEX" }, */
+/* { "CONCATENATE","CONCATENATE" }, */
+/* { "CONFIDENCE","CONFIDENCE" }, */
+/* { "CONVERT","CONVERT" }, */
+/* { "CORREL","CORREL" }, */
+/* { "COS","COS" }, */
+/* { "COSH","COSH" }, */
+/* { "COT","COT" }, */
+/* /\* { "COTH","COTH" }, *\/ */
+/* { "COUNT","COUNT" }, */
+/* { "COUNTA","COUNTA" }, */
+/* { "COUNTBLANK","COUNTBLANK" }, */
+/* { "COUNTIF","COUNTIF" }, */
+/* /\* { "COUNTIFS","COUNTIFS" }, *\/ */
+/* { "COUPDAYBS","COUPDAYBS" }, */
+/* { "COUPDAYS","COUPDAYS" }, */
+/* { "COUPDAYSNC","COUPDAYSNC" }, */
+/* { "COUPNCD","COUPNCD" }, */
+/* { "COUPNUM","COUPNUM" }, */
+/* { "COUPPCD","COUPPCD" }, */
+/* { "COVAR","COVAR" }, */
+/* { "CRITBINOM","CRITBINOM" }, */
+/* /\* { "CSC","CSC" }, *\/ */
+/* /\* { "CSCH","CSCH" }, *\/ */
+/* { "CUMIPMT","CUMIPMT" }, */
+/* { "CUMPRINC","CUMPRINC" }, */
+/* { "DATE","DATE" }, */
+/* { "DATEDIF","DATEDIF" }, */
+/* { "DATEVALUE","DATEVALUE" }, */
+/* { "DAVERAGE","DAVERAGE" }, */
+/* { "DAY","DAY" }, */
+/* /\* { "DAYS","DAYS" }, *\/ */
+/* { "DAYS360","DAYS360" }, */
+/* { "DB","DB" }, */
+/* { "DCOUNT","DCOUNT" }, */
+/* { "DCOUNTA","DCOUNTA" }, */
+/* { "DDB","DDB" }, */
+/* /\* { "DDE","DDE" }, *\/ */
+/* { "DEC2BIN","DEC2BIN" }, */
+/* { "DEC2HEX","DEC2HEX" }, */
+/* { "DEC2OCT","DEC2OCT" }, */
+/* { "DECIMAL","DECIMAL" }, */
+/* { "DEGREES","DEGREES" }, */
+/* { "DELTA","DELTA" }, */
+/* { "DEVSQ","DEVSQ" }, */
+/* { "DGET","DGET" }, */
+/* { "DISC","DISC" }, */
+/* { "DMAX","DMAX" }, */
+/* { "DMIN","DMIN" }, */
+/* { "DOLLAR","DOLLAR" }, */
+/* { "DOLLARDE","DOLLARDE" }, */
+/* { "DOLLARFR","DOLLARFR" }, */
+/* { "DPRODUCT","DPRODUCT" }, */
+/* { "DSTDEV","DSTDEV" }, */
+/* { "DSTDEVP","DSTDEVP" }, */
+/* { "DSUM","DSUM" }, */
+/* { "DURATION","DURATION" }, */
+/* { "DVAR","DVAR" }, */
+/* { "DVARP","DVARP" }, */
+/* { "EDATE","EDATE" }, */
+/* { "EFFECT","EFFECT" }, */
+/* { "EOMONTH","EOMONTH" }, */
+/* { "ERF","ERF" }, */
+/* { "ERFC","ERFC" }, */
+/* { "ERROR.TYPE","ERROR.TYPE" }, */
+/* { "EUROCONVERT","EUROCONVERT" }, */
+/* { "EVEN","EVEN" }, */
+/* { "EXACT","EXACT" }, */
+/* { "EXP","EXP" }, */
+/* { "EXPONDIST","EXPONDIST" }, */
+/* { "FACT","FACT" }, */
+/* { "FACTDOUBLE","FACTDOUBLE" }, */
+/* { "FALSE","FALSE" }, */
+/* { "FDIST","FDIST" },                 different definition */
+/* { "FIND","FIND" }, */
+/* /\* { "FINDB","FINDB" }, *\/ */
+/* { "FINV","FINV" },                  different definition*/
+/* { "FISHER","FISHER" }, */
+/* { "FISHERINV","FISHERINV" }, */
+/* { "FIXED","FIXED" }, */
+/* { "FLOOR","FLOOR" }, */
+/* { "FORECAST","FORECAST" }, */
+/* /\* { "FORMULA","FORMULA" }, *\/ */
+/* { "FREQUENCY","FREQUENCY" }, */
+/* { "FTEST","FTEST" }, */
+/* { "FV","FV" }, */
+/* { "FVSCHEDULE","FVSCHEDULE" }, */
+/* /\* { "GAMMA","GAMMA" }, *\/ */
+/* { "GAMMADIST","GAMMADIST" }, */
+/* { "GAMMAINV","GAMMAINV" }, */
+/* { "GAMMALN","GAMMALN" }, */
+/* /\* { "GAUSS","GAUSS" }, *\/ */
+/* { "GCD","GCD" }, */
+/* { "GEOMEAN","GEOMEAN" }, */
+/* { "GESTEP","GESTEP" }, */
+/* { "GETPIVOTDATA","GETPIVOTDATA" }, */
+/* { "GROWTH","GROWTH" }, */
+/* { "HARMEAN","HARMEAN" }, */
+/* { "HEX2BIN","HEX2BIN" }, */
+/* { "HEX2DEC","HEX2DEC" }, */
+/* { "HEX2OCT","HEX2OCT" }, */
+/* { "HLOOKUP","HLOOKUP" }, */
+/* { "HOUR","HOUR" }, */
+/* { "HYPERLINK","HYPERLINK" }, */
+/* { "HYPGEOMDIST","HYPGEOMDIST" }, */
+/* { "IF","IF" }, */
+/* { "IFERROR","IFERROR" }, */
+/* /\* { "IFNA","IFNA" }, *\/ */
+/* { "IMABS","IMABS" }, */
+/* { "IMAGINARY","IMAGINARY" }, */
+/* { "IMARGUMENT","IMARGUMENT" }, */
+/* { "IMCONJUGATE","IMCONJUGATE" }, */
+/* { "IMCOS","IMCOS" }, */
+/* { "IMCOT","IMCOT" }, */
+/* { "IMCSC","IMCSC" }, */
+/* { "IMCSCH","IMCSCH" }, */
+/* { "IMDIV","IMDIV" }, */
+/* { "IMEXP","IMEXP" }, */
+/* { "IMLN","IMLN" }, */
+/* { "IMLOG10","IMLOG10" }, */
+/* { "IMLOG2","IMLOG2" }, */
+/* { "IMPOWER","IMPOWER" }, */
+/* { "IMPRODUCT","IMPRODUCT" }, */
+/* { "IMREAL","IMREAL" }, */
+/* { "IMSEC","IMSEC" }, */
+/* { "IMSECH","IMSECH" }, */
+/* { "IMSIN","IMSIN" }, */
+/* { "IMSQRT","IMSQRT" }, */
+/* { "IMSUB","IMSUB" }, */
+/* { "IMSUM","IMSUM" }, */
+/* { "IMTAN","IMTAN" }, */
+/* { "INDEX","INDEX" }, */
+/* { "INDIRECT","INDIRECT" }, */
+/* { "INFO","INFO" }, */
+/* { "INT","INT" }, */
+/* { "INTERCEPT","INTERCEPT" }, */
+/* { "INTRATE","INTRATE" }, */
+/* { "IPMT","IPMT" }, */
+/* { "IRR","IRR" }, */
+/* { "ISBLANK","ISBLANK" }, */
+/* { "ISERR","ISERR" }, */
+/* { "ISERROR","ISERROR" }, */
+/* { "ISEVEN","ISEVEN" }, */
+/* /\* { "ISFORMULA","ISFORMULA" }, *\/ */
+/* { "ISLOGICAL","ISLOGICAL" }, */
+/* { "ISNA","ISNA" }, */
+/* { "ISNONTEXT","ISNONTEXT" }, */
+/* { "ISNUMBER","ISNUMBER" }, */
+/* { "ISODD","ISODD" }, */
+/* { "ISOWEEKNUM","ISOWEEKNUM" }, */
+/* { "ISPMT","ISPMT" }, */
+/* { "ISREF","ISREF" }, */
+/* { "ISTEXT","ISTEXT" }, */
+/* /\* { "JIS","JIS" }, *\/ */
+/* { "KURT","KURT" }, */
+/* { "LARGE","LARGE" }, */
+/* { "LCM","LCM" }, */
+/* { "LEFT","LEFT" }, */
+/* { "LEFTB","LEFTB" }, */
+/* { "LEGACY.CHIDIST","LEGACY.CHIDIST" }, */
+/* { "LEGACY.CHIINV","LEGACY.CHIINV" }, */
+/* { "LEGACY.CHITEST","LEGACY.CHITEST" }, */
+/* { "LEGACY.FDIST","LEGACY.FDIST" }, */
+/* { "LEGACY.FINV","LEGACY.FINV" }, */
+/* { "LEGACY.NORMSDIST","LEGACY.NORMSDIST" }, */
+/* { "LEGACY.NORMSINV","LEGACY.NORMSINV" }, */
+/* { "LEN","LEN" }, */
+/* { "LENB","LENB" }, */
+/* { "LINEST","LINEST" }, */
+/* { "LN","LN" }, */
+/* { "LOG","LOG" }, */
+/* { "LOG10","LOG10" }, */
+/* { "LOGEST","LOGEST" }, */
+/* { "LOGINV","LOGINV" }, */
+/* { "LOGNORMDIST","LOGNORMDIST" }, */
+/* { "LOOKUP","LOOKUP" }, */
+/* { "LOWER","LOWER" }, */
+/* { "MATCH","MATCH" }, */
+/* { "MAX","MAX" }, */
+/* { "MAXA","MAXA" }, */
+/* { "MDETERM","MDETERM" }, */
+/* { "MDURATION","MDURATION" }, */
+/* { "MEDIAN","MEDIAN" }, */
+/* { "MID","MID" }, */
+/* /\* { "MIDB","MIDB" }, *\/ */
+/* { "MIN","MIN" }, */
+/* { "MINA","MINA" }, */
+/* { "MINUTE","MINUTE" }, */
+/* { "MINVERSE","MINVERSE" }, */
+/* { "MIRR","MIRR" }, */
+/* { "MMULT","MMULT" }, */
+/* { "MOD","MOD" }, */
+/* { "MODE","MODE" }, */
+/* { "MONTH","MONTH" }, */
+/* { "MROUND","MROUND" }, */
+/* { "MULTINOMIAL","MULTINOMIAL" }, */
+/* /\* { "MULTIPLE.OPERATIONS","MULTIPLE.OPERATIONS" }, *\/ */
+/* /\* { "MUNIT","MUNIT" }, *\/ */
+/* { "N","N" }, */
+/* { "NA","NA" }, */
+/* { "NEGBINOMDIST","NEGBINOMDIST" }, */
+/* { "NETWORKDAYS","NETWORKDAYS" }, */
+/* { "NOMINAL","NOMINAL" }, */
+/* { "NORMDIST","NORMDIST" }, */
+/* { "NORMINV","NORMINV" }, */
+/* { "NOT","NOT" }, */
+/* { "NOW","NOW" }, */
+/* { "NPER","NPER" }, */
+/* { "NPV","NPV" }, */
+/* /\* { "NUMBERVALUE","NUMBERVALUE" }, *\/ */
+/* { "OCT2BIN","OCT2BIN" }, */
+/* { "OCT2DEC","OCT2DEC" }, */
+/* { "OCT2HEX","OCT2HEX" }, */
+/* { "ODD","ODD" }, */
+/* { "ODDFPRICE","ODDFPRICE" }, */
+/* { "ODDFYIELD","ODDFYIELD" }, */
+/* { "ODDLPRICE","ODDLPRICE" }, */
+/* { "ODDLYIELD","ODDLYIELD" }, */
+/* { "OFFSET","OFFSET" }, */
+/* { "OR","OR" }, */
+/* /\* { "PDURATION","PDURATION" }, *\/ */
+/* { "PEARSON","PEARSON" }, */
+/* { "PERCENTILE","PERCENTILE" }, */
+/* { "PERCENTRANK","PERCENTRANK" }, */
+/* { "PERMUT","PERMUT" }, */
+/* /\* { "PERMUTATIONA","PERMUTATIONA" }, *\/ */
+/* /\* { "PHI","PHI" }, *\/ */
+/* { "PI","PI" }, */
+/* { "PMT","PMT" }, */
+/* { "POISSON","POISSON" }, */
+/* { "POWER","POWER" }, */
+/* { "PPMT","PPMT" }, */
+/* { "PRICE","PRICE" }, */
+/* { "PRICEDISC","PRICEDISC" }, */
+/* { "PRICEMAT","PRICEMAT" }, */
+/* { "PROB","PROB" }, */
+/* { "PRODUCT","PRODUCT" }, */
+/* { "PROPER","PROPER" }, */
+/* { "PV","PV" }, */
+/* { "QUARTILE","QUARTILE" }, */
+/* { "QUOTIENT","QUOTIENT" }, */
+/* { "RADIANS","RADIANS" }, */
+/* { "RAND","RAND" }, */
+/* { "RANDBETWEEN","RANDBETWEEN" }, */
+/* { "RANK","RANK" }, */
+/* { "RATE","RATE" }, */
+/* { "RECEIVED","RECEIVED" }, */
+/* { "REPLACE","REPLACE" }, */
+/* /\* { "REPLACEB","REPLACEB" }, *\/ */
+/* { "REPT","REPT" }, */
+/* { "RIGHT","RIGHT" }, */
+/* /\* { "RIGHTB","RIGHTB" }, *\/ */
+/* { "ROMAN","ROMAN" }, */
+/* { "ROUND","ROUND" }, */
+/* { "ROUNDDOWN","ROUNDDOWN" }, */
+/* { "ROUNDUP","ROUNDUP" }, */
+/* { "ROW","ROW" }, */
+/* { "ROWS","ROWS" }, */
+/* /\* { "RRI","RRI" }, *\/ */
+/* { "RSQ","RSQ" }, */
+/* { "SEARCH","SEARCH" }, */
+/* /\* { "SEARCHB","SEARCHB" }, *\/ */
+/* { "SEC","SEC" }, */
+/* { "SECH","SECH" }, */
+/* { "SECOND","SECOND" }, */
+/* { "SERIESSUM","SERIESSUM" }, */
+/* /\* { "SHEET","SHEET" }, *\/ */
+/* /\* { "SHEETS","SHEETS" }, *\/ */
+/* { "SIGN","SIGN" }, */
+/* { "SIN","SIN" }, */
+/* { "SINH","SINH" }, */
+/* { "SKEW","SKEW" }, */
+/* { "SKEWP","SKEWP" }, */
+/* { "SLN","SLN" }, */
+/* { "SLOPE","SLOPE" }, */
+/* { "SMALL","SMALL" }, */
+/* { "SQRT","SQRT" }, */
+/* { "SQRTPI","SQRTPI" }, */
+/* { "STANDARDIZE","STANDARDIZE" }, */
+/* { "STDEV","STDEV" }, */
+/* { "STDEVA","STDEVA" }, */
+/* { "STDEVP","STDEVP" }, */
+/* { "STDEVPA","STDEVPA" }, */
+/* { "STEYX","STEYX" }, */
+/* { "SUBSTITUTE","SUBSTITUTE" }, */
+/* { "SUBTOTAL","SUBTOTAL" }, */
+/* { "SUM","SUM" }, */
+/* { "SUMIF","SUMIF" }, */
+/* /\* { "SUMIFS","SUMIFS" }, *\/ */
+/* { "SUMPRODUCT","SUMPRODUCT" }, */
+/* { "SUMSQ","SUMSQ" }, */
+/* { "SUMX2MY2","SUMX2MY2" }, */
+/* { "SUMX2PY2","SUMX2PY2" }, */
+/* { "SUMXMY2","SUMXMY2" }, */
+/* { "SYD","SYD" }, */
+/* { "T","T" }, */
+/* { "TAN","TAN" }, */
+/* { "TANH","TANH" }, */
+/* { "TBILLEQ","TBILLEQ" }, */
+/* { "TBILLPRICE","TBILLPRICE" }, */
+/* { "TBILLYIELD","TBILLYIELD" }, */
+/* { "TDIST","TDIST" }, */
+/* { "TEXT","TEXT" }, */
+/* { "TIME","TIME" }, */
+/* { "TIMEVALUE","TIMEVALUE" }, */
+/* { "TINV","TINV" }, */
+/* { "TODAY","TODAY" }, */
+/* { "TRANSPOSE","TRANSPOSE" }, */
+/* { "TREND","TREND" }, */
+/* { "TRIM","TRIM" }, */
+/* { "TRIMMEAN","TRIMMEAN" }, */
+/* { "TRUE","TRUE" }, */
+/* { "TRUNC","TRUNC" }, */
+/* { "TTEST","TTEST" }, */
+/* { "TYPE","TYPE" }, */
+/* { "UNICHAR","UNICHAR" }, */
+/* { "UNICODE","UNICODE" }, */
+/* /\* { "USDOLLAR","USDOLLAR" }, *\/ */
+/* { "UPPER","UPPER" }, */
+/* { "VALUE","VALUE" }, */
+/* { "VAR","VAR" }, */
+/* { "VARA","VARA" }, */
+/* { "VARP","VARP" }, */
+/* { "VARPA","VARPA" }, */
+/* { "VDB","VDB" }, */
+/* { "VLOOKUP","VLOOKUP" }, */
+/* { "WEEKDAY","WEEKDAY" }, */
+/* { "WEEKNUM","WEEKNUM" }, */
+/* { "WEIBULL","WEIBULL" }, */
+/* { "WORKDAY","WORKDAY" }, */
+/* { "XIRR","XIRR" }, */
+/* { "XNPV","XNPV" }, */
+/* { "XOR","XOR" }, */
+/* { "YEAR","YEAR" }, */
+/* { "YEARFRAC","YEARFRAC" }, */
+/* { "YIELD","YIELD" }, */
+/* { "YIELDDISC","YIELDDISC" }, */
+/* { "YIELDMAT","YIELDMAT" }, */
+/* { "ZTEST","ZTEST" }, */
 			{ NULL, NULL }
 		};
 		static GHashTable *namemap = NULL;
@@ -1293,7 +1874,7 @@ odf_expr_func_handler (GnmConventionsOut *out, GnmExprFunction const *func)
 
 		if (new_name == NULL) {
 			char *new_u_name;
-			if (*(name+1) == '.') 
+			if (*(name + 1) == '.')
 				g_string_append (target, "ORG.GNUMERIC.");
 			new_u_name = g_ascii_strup (name, -1);
 			g_string_append (target, new_u_name);
[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]