<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:sbergman@redhat.com" title="Stephan Bergmann <sbergman@redhat.com>"> <span class="fn">Stephan Bergmann</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Mid function doesn't replace to nothing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121920">bug 121920</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>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>DUPLICATE
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Mid function doesn't replace to nothing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121920#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Mid function doesn't replace to nothing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121920">bug 121920</a>
from <span class="vcard"><a class="email" href="mailto:sbergman@redhat.com" title="Stephan Bergmann <sbergman@redhat.com>"> <span class="fn">Stephan Bergmann</span></a>
</span></b>
<pre>(In reply to sunweb from <a href="show_bug.cgi?id=121920#c9">comment #9</a>)
<span class="quote">> Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=147734" name="attach_147734" title="Macros inside this ODS file">attachment 147734</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=147734&action=edit" title="Macros inside this ODS file">[details]</a></span>
> Macros inside this ODS file</span >
Ah, so the result of
mystring=" 40"
i = InStr(mystring, " ")
Mid(mystring, i, Len(" "), CHR$(8205))
is a mystring of length 3, with a first invisible character U+200D ZERO WIDTH
JOINER.
The original issue from <a href="show_bug.cgi?id=121920#c0">comment 0</a> is a duplicate of issue 121325, and should be
fixed in LO 6.1.4, as confirmed in <a href="show_bug.cgi?id=121920#c3">comment 3</a>.
*** This bug has been marked as a duplicate of <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - 4-argument form of Mid() BASIC function broken in 6.x (worked in 5.x and OO)"
href="show_bug.cgi?id=121325">bug 121325</a> ***</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>