Development/Calc/Spreadsheet Functions/not yet implemented

    From The Document Foundation Wiki

    List of Spreadsheet Functions Currently Not Supported in LO

    This is a list of functions which other spreadsheet applications or standards (like ODF or OOXML) have integrated but which currently are not supported in LibreOffice. Some of these have workarounds while others do not. This list originated from bug report tdf#46918 which has been closed and moved to the wiki in order for the LibreOffice team to better organize and prioritize the list of functions. When a function is in the works the assigned developer will open a bug corresponding to that particular function. If there is a particular function which a user thinks is really valuable but not in LibreOffice, please email the development mailing list and we'll see if someone can pick it up.

    If you pick up a function to implement please update the wiki table below and create a new bug in bugzilla for that particular function.

    Table of Functions Not Supported in LibreOffice Calc

    Function Name Function Description Workaround? introduced in Bugzilla entry Development Status
    BASETONUM similar to hex2bin etc. just with another base ? Apple Numbers 2009 tdf#97334 not started
    CALL Calls a procedure in a dynamic link library or code resource. There are two syntax forms of this function. Use syntax 1 only with a previously registered code resource, which uses arguments from the REGISTER function ? Excel 201X ? not started
    CUBEKPIMEMBER Returns a key performance indicator (KPI) property and displays the KPI name in the cell No Excel 2007 tdf#46918 Not started
    CUBEMEMBER Returns a member or tuple from the cube No Excel 2007 tdf#46918 Not started
    CUBEMEMBERPROPERTY Returns the value of a member property from the cube No Excel 2007 tdf#46918 Not started
    CUBEDRANKEDMEMBER Returns the nth, or ranked, member in a set No Excel 2007 tdf#46918 Not started
    CUBESET Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel No Excel 2007 tdf#46918 Not started
    CUBESETCOUNT Returns the number of items in a set. No Excel 2007 tdf#46918 Not started
    CUBEVALUE Returns an aggregate value from the cube. No Excel 2007 tdf#46918 Not started
    DAYNAME DAYNAME(1) = Sunday Yes Apple Numbers 2009 tdf#97334 not started
    DBCS Converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings. For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters. ? Excel 2013 ? not started
    DUR2DAYS the duration in days Yes Apple Numbers 2009 tdf#97334 not started
    DUR2HOURS the duration in hours Yes Apple Numbers 2009 tdf#97334 not started
    DUR2MILLISECONDS the duration in milliseconds Yes Apple Numbers 2009 tdf#97334 not started
    DUR2MINUTES the duration in minutes Yes Apple Numbers 2009 tdf#97334 not started
    DUR2SECONDS the duration in seconds Yes Apple Numbers 2009 tdf#97334 not started
    DUR2WEEKS the duration in weeks Yes Apple Numbers 2009 tdf#97334 not started
    DURATION the duration between two dates Yes Apple Numbers 2009 tdf#97334 not started
    MONTHNAME MONTHNAME(11) = November Yes Apple Numbers 2009 tdf#97334 not started
    NUMTOBASE see above: BASETONUM ? Apple Numbers 2009 tdf#97334 not started
    PHONETIC Extracts the phonetic (furigana) characters from a text string. ? Excel 2007 tdf#89976 not started
    REGISTER.ID Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered. If the DLL or code resource has not been registered, this function registers the DLL or code resource and then returns the register ID. REGISTER.ID can be used on worksheets (unlike REGISTER), but you cannot specify a function name and argument names with REGISTER.ID ? Excel 2007 ? not started
    RTD Retrieves real time data from a program that supports COM automation No Excel 2007 tdf#46918 Not started
    SQL.REQUEST Connects with an external data source, and runs a query from a worksheet. SQL.REQUEST then returns the result as an array without the need for macro programming. If this function is not available, you must install the Microsoft Excel ODBC add-in program (XLODBC.XLA). ? Excel 2007. Note: SQL.REQUEST has been replaced with Power Query since Excel 2010 ? not started
    STRIPDURATION a compatibility function for giving back either the duration or the input, see ticket for a more comprehensive explanation Yes Apple Numbers 2009 tdf#97334 not started
    TEXTSPLIT Splits text strings by using column and row delimiters. Yes Excel for M365 tdf#150866 not started
    YEN Converts a number to text, using the ¥ (yen) currency format, with the number rounded to a specified place ? Excel 200X Japanese version ? not started

    Hint: You could use this List of new functions in Excel 2010 and/or New functions in Excel 2013 to cross-check.

    Related Bugs

    META bug Calc functions bugs and enhancements

    Query any of the above functions in Bugzilla (link outdated)

    Related Work in OpenOffice.org wiki

    See also