User talk:Jeanweber
Edit by Jean: I did not compile the comparison. You may wish to contact the person who did: Zeki Bildirici <zeki@ozgurlukicin.com>
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.