User talk:Jeanweber

    From The Document Foundation Wiki

    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.