Development/Calc/Spreadsheet Functions/not yet implemented
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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)