<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:david_lynch@blueyonder.co.uk" title="David Lynch <david_lynch@blueyonder.co.uk>"> <span class="fn">David Lynch</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Enhancement to Calc function SUBSTITUTE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107369">bug 107369</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Enhancement to Calc function SUBSTITUTE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107369#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Enhancement to Calc function SUBSTITUTE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107369">bug 107369</a>
from <span class="vcard"><a class="email" href="mailto:david_lynch@blueyonder.co.uk" title="David Lynch <david_lynch@blueyonder.co.uk>"> <span class="fn">David Lynch</span></a>
</span></b>
<pre>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 <a href="show_bug.cgi?id=107369#c5">Comment 5</a>, 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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>