[Libreoffice-bugs] [Bug 107369] Enhancement to Calc function SUBSTITUTE

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
This is nothing for SUBSTITUTE as SUBSTITUTE is defined to take scalar values
as arguments, which is implemented by various spreadsheet applications, and
thus in array context already acts differently than what you propose. It could
be only implemented as a new function.

I'm not sure I understand the use case though. You want an array (or range
reference for that matter) of SearchText be searched subsequently in Text from
position Occurrence, and then for a match replace it with the corresponding
element of NewText and then continue with the next SearchText from the same
Occurrence position (or even a different one if Occurrence was a range/array as
well) and the result should be a single text string, not an array? Did I get
that right? That's quite a specialized use case..

-- 
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/20170428/f941f21d/attachment.html>