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

[bugzilla-daemon at bugs.documentfoundation.org]

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

David Lynch <david_lynch at blueyonder.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #7 from David Lynch <david_lynch at blueyonder.co.uk> ---
Text is never an array. Occurrence is never an array. The function should be
implemented as:
For each element SearchText[i]
        ST = SearchText[i]
        if NewText is an array
                NT = NewText[i]
        else
                NT = NewText
        end if
        existing_SUBSTITUTE(Text,ST,NT,Occurrence)
end for

In Comment 5, Eike writes:
"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."

I don't understand this. Other Libreoffice functions, such as ROW and COLUMN,
can take either scalar or array arguments and behave appropriately.

-- 
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/20170823/cb5879aa/attachment.html>