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

From
OASIS Issues Tracker <>
Date
2017-10-14T19:27:58+00:00
ID
Thread
[OASIS Issue Tracker] (OFFICE-1141) Public Comment: Expand CONCATENATE() to Ranges
[ https://issues.oasis-open.org/browse/OFFICE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67832#comment-67832 ] 

Andreas Guelzow edited comment on OFFICE-1141 at 10/14/17 7:27 PM:
-------------------------------------------------------------------

In Gnumeric, concat and concatenate are synonyms and they implement COM.MICROSOFT.CONCAT. Specifically =concatenate(I1:K2) is the same as =concat(I1:K2).

In LibreOffice 5.0.3.2, =concatenate(I1:K2) is the same as =com.microsoft.concat(I1:K2). So how do these functions differ in LibreOffice? Does LibreOffice in fact implement the ODF function CONCATENATE?



was (Author: aguelzow):
In Gnumeric, concat and concatenate are synonyms and they implement COM.MICROSOFT.CONCAT. Specifically =concatenate(I1:K1) is the same as =concat(I1:K1).

In LibreOffice 5.0.3.2, =concatenate(I1:K1) is the same as ==com.microsoft.concat(I2:K2). So how do these functions differ in LibreOffice? Does LibreOffice in fact implement the ODF function 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 <> 
> 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)