User talk:Jeanweber

From The Document Foundation Wiki
Jump to: navigation, search

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.