<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><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">107369</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Enhancement to Calc function SUBSTITUTE
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.3.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>david_lynch@blueyonder.co.uk
</td>
</tr></table>
<p>
<div>
<pre>SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence)
Text is the text string in which text segments are to be exchanged.
SearchText is the text segment that is to be replaced (a number of
times).
NewText is the text string that is to replace the text segment.
Occurrence (optional) indicates which occurrence of the search text is
to be replaced. If this parameter is omitted the search text is replaced
throughout.
Enhancement requested:
*** If SearchText and NewText are both arrays, they must be the same length:
then each array element of NewText replaces the corresponding element of
SearchText. If only SearchText is an array, NewText replaces each element of
SearchText. ***
This enhancement is compatible with existing SUBSTITUTE.</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>