Re: [libreoffice-users] Concatenate Function inCalc

On 4/2/19 2:54 PM, Robert Großkopf wrote:
> > This thread is about CONCATENATE being dysfunctional in that it accepts
> > ranges, but does not act on them correctly. Please stop referring to CONCAT
> > as the reason that CONCATENATE is broken.
>
> Please read the first mail of jonathon.
> "With previous versions of LibO, concatenate(b1:b200) would concatenate
> all cells between b1 and b200."
> He has been looking for a functionality of CONCAT and wanted to use
> CONCATENATE, which never worked in this way.

It doesn't matter if concat or concatentate is the correct command to
use. Neither concat(a20:a200) nor concatentate(a20:a200) return the
expected the result. Both return the value in a20.

Prior to LibO 6.2.2, (a20:a200) would return a single string, containing
the contents all the cells between a20 & a200, inclusive.

###

The only work around I've found is to create half a dozen cells,
concatenating 30 cells each,then concatenating them, and then
concatenating them, if needed.

jonathon

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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