Bug 155805 - Support for string concatenation with separator
Summary: Support for string concatenation with separator
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2023-06-12 22:00 UTC by Eyal Rozenberg
Modified: 2023-06-12 22:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2023-06-12 22:00:00 UTC 
I want to be able to concatenate strings with a separator between them, but such that the separator is only used for non-empty string, i.e. with separator " ",

"Foo", "Bar", "" => "Foo Bar"
"Foo", "", "Baz" => "Foo Baz"
"Foo", "", ""    => "Foo"

the CONCAT and CONCATENATE functions don't offer this functionality (see also text/scalc/01/func_concat.html in the help docs).