User talk:Jeanweber

Edit by Jean: I did not compile the comparison. You may wish to contact the person who did: Zeki Bildirici 

I will indicate that on the wiki. I should have done that earlier.

Thanks!

Dear Jean, I have just seen your extensive Excel <-> LibreOffice Calc functions comparison (https://wiki.documentfoundation.org/File:Excel2013_Calc_Functions_Comparison.ods). I was just wondering whether the list is complete or up-to-date with current LibreOffice versions, e.g.:

https://wiki.documentfoundation.org/ReleaseNotes/4.0#Calc
 * XOR function added
 * AVERAGEIF, SUMIFS, AVERAGEIFS and COUNTIFS added
 * IFERROR and IFNA added
 * Unique functions added in LO 4.1:
 * OPT_BARRIER, OPT_PROB_HIT, OPT_PROB_INMMONEY, OPT_TOUCH

https://wiki.documentfoundation.org/ReleaseNotes/4.1#Calc
 * NUMBERVALUE added
 * SKEWP added (in Excel Skew.P)
 * The following functions are handled, name specialties are given as (in parentheses the Calc en-US UI name) [in brackets the ODFF name]: ACOT, ACOTH, ARABIC, BASE, BINOM.DIST.RANGE (B) [BINOM.DIST.RANGE], BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, COMBINA, COT, COTH, CSC, CSCH, DAYS, DECIMAL, FORMULATEXT (FORMULA) [FORMULA], GAMMA, GAUSS, IFNA, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN, ISFORMULA, MUNIT, NUMBERVALUE, PDURATION (DURATION) [PDURATION], PERMUTATIONA, PHI, RRI, SEC, SECH, SHEET, SHEETS, SKEW.P (SKEWP) [SKEWP], UNICHAR, UNICODE, XOR

https://wiki.documentfoundation.org/ReleaseNotes/3.5#Calc
 * BITAND, BITOR, BITXOR BITRSHIFT and BITLSHIFT added
 * SEC, CSC, SECH and CSCH added

https://wiki.documentfoundation.org/ReleaseNotes/3.6#Calc
 * DATEDIF added
 * IMTAN, IMSEC, IMCSC, IMCOT, IMSINH, IMCOSH, IMSECH and IMCSCH added

https://wiki.documentfoundation.org/ReleaseNotes/4.2
 * WEBSERVICE and FILTERXML added

There must also be many other functions which are unique to LibreOffice for a longer time, because the total number of functions in 4.1 was slightly higher than the total number of functions in Excel 2010.