Development/Calc/Spreadsheet Functions/not yet implemented

From The Document Foundation Wiki
Jump to: navigation, search

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
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