[OASIS Issue Tracker] (OFFICE-1141) Public Comment: Expand CONCATENATE() to Ranges

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ https://issues.oasis-open.org/browse/OFFICE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67831#comment-67831 ] 

Regina Henschel commented on OFFICE-1141:
-----------------------------------------

LibreOffice has implemented
COM.MICROSOFT.CONCAT
and
COM.MICROSOFT.TEXTJOIN

CONCAT extends CONCATENATE to ranges and TEXTJOIN extends CONCAT with a delimiter.
Both functions are available in Excel 2016. Their descriptions are in
https://support.office.com/en-us/article/CONCAT-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2
https://support.office.com/en-us/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c

I do not see the need for changing the definition of CONCATENATE.

> Public Comment: Expand CONCATENATE() to Ranges
> ----------------------------------------------
>
>                 Key: OFFICE-1141
>                 URL: https://issues.oasis-open.org/browse/OFFICE-1141
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Rob Weir
>            Priority: Blocker
>             Fix For: ODF 1.3
>
>
> Copied from office-comment list
> Original author: Leonard Mada <discoleo@gmx.net> 
> Original date: 6 Dec 2008 20:17:28 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200812/msg00000.html



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)