Bug 124502

Summary:	CALC-HELP: Missing CONCAT in Calc-Help
Product:	LibreOffice	Reporter:	Robert Großkopf <robert>
Component:	Documentation	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv, oliver.brinzing, olivier.hallot
Priority:	medium
Version:	6.2.2.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	80430

Description Robert Großkopf 2019-04-02 14:39:20 UTC

Open Calc.
Open the function wizard.
There is a function CONCAT (which allows to accept cell ranges). This function isn't part of the help of LO. Only CONCATENATE is part of the help and this function doesn't accept cell ranges.

Tested with LO 6.2.2.2 on OpenSUSE 64bit rpm Linux.

Comment 1 Oliver Brinzing 2019-04-02 16:50:40 UTC

reproducible with:

Version: 6.3.0.0.alpha0+ (x64)
Build ID: bf2f0c913774c90e4c9a65119d0219187bb4498c
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

Comment 2 m_a_riosv 2019-04-04 07:54:57 UTC

We could add TEXTJOIN() that it's similar to CONCAT() but a bit powerful. That also has no help.

TEXTJOIN(Delimiter, Skip empty cells, Text1, Text2,..)
Combines several text items into one, accepts cell ranges as arguments.
Uses delimiter between items.

Comment 3 Olivier Hallot 2019-04-30 13:22:48 UTC


*** This bug has been marked as a duplicate of bug 99517 ***