https://bugs.documentfoundation.org/show_bug.cgi?id=155805

            Bug ID: 155805
           Summary: Support for string concatenation with separator
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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).

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to