[Libreoffice-bugs] [Bug 123001] New: A little improvement to CONCATENATE/CONCAT, please?

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123001
           Summary: A little improvement to CONCATENATE/CONCAT, please?
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: turbobeholder at mail.ru

Description:
Almost the same as CONCATENATE/CONCAT, only taking separator as a fixed
argument, to be added after every non-empty string if any non-empty string is
added after it.
CONCATENATESEP("Separator"; "Text1"; ...; "Text30")
CONCATSEP ("Separator"; {"Texts"})

Of course, while lumping text together without separators tend to make it
unreadable, once separators are supported, it would make sense to add a
counterpart of SUMIF/SUMIFS, but for strings.


Steps to Reproduce:
1. I want to make a readable digest of articular entries picked out of a table.


Actual Results:
There's no way to do it now, since even DGET throws an error if there's more
than one result.

Expected Results:
$TooManyColumns.Y2 ... $TooManyColumns.Y199:
=$B199&"/"&$C199&$D199&" @"&$E199&CHAR(10)
$Summary.E33:
=CONCATSEPIFS(CHAR(10), $TooManyColumns.$Y$2:$Y$199,
$TooManyColumns.$B$2:$B$199,"="&$A33,
$TooManyColumns.$G$2:$G$199,"="&$D33)&T(STYLE("text_smaller"))


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190127/ff6f8f35/attachment-0001.html>