<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</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;">CC</td>
<td>
</td>
<td>erack@redhat.com
</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#c5">Comment # 5</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:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>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..</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>