OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: [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=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 <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)


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]