[ https://issues.oasis-open.org/browse/OFFICE-1141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67833#comment-67833 ]
Regina Henschel commented on OFFICE-1141:
-----------------------------------------
Yes, in LibreOffice
=CONCATENATE(A1;A2;A3;A4) in UI is of:=CONCATENATE([.A1];[.A2];[.A3];[.A4]) in file, and it works.
=CONCATENATE(A1:A4) in UI is of:=CONCATENATE([.A1:.A4]) in file and results in an error because of the range.
> 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)
