I am running 6.07 and =CONCATENATE(A2:A4) gives #VALUE =CONCATENATE(A2,A3,A4) concatenates A2, A3 and A4 correctly. Steve
On 02/04/2019 14:43, Michael Manning wrote: > I am running an older version of LibreOffice > Version: 5.1.6.2 > Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6 > CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; > Locale: en-AU (en_AU.UTF-8); Calc: group > running on Linux Mint 18.3 > > the function concatenate(text1:text4) gives the result text1 > the function concatenate(text1, text2, text3, text4) gives the correct > result of text1text2text3text4 > > regards > > Mike > > > On Tue, 2 Apr 2019 at 12:19, jonathon <[email protected]> wrote: > >> All: >> >> LibreOffice 6.2.2.2 >> CPU: 8 Threads >> OS: Linux 4.2 >> Locale en_ZA >> >> With previous versions of LibO, concatenate(b1:b200) would concatenate >> all cells between b1 and b200. >> >> With LibO 6.2.2.2, concatenate(b1:b200) returns the data in b1. >> >> a) When was this functionality changed? >> I didn't come across it in any of the 6.x betas/daily builds that I tested; >> >> b) Why was this functionality changed? >> >> jonathon >> >> -- >> To unsubscribe e-mail to: [email protected] >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
