<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Trim() function doesn't trim spaces"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113903">bug 113903</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>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>xiscofauli@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Trim() function doesn't trim spaces"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113903#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Trim() function doesn't trim spaces"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113903">bug 113903</a>
from <span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span></b>
<pre>Trim function removes the spaces and tabs from the beginning and end of the
string, but not from the middle. If you want to remove the spaces in between,
you need to use =SUBSTITUTE("a b c"; " "; "" )
Closing as RESOLVED NOTABUG</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>