<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ctac113@mail.ru" title="CTAC <ctac113@mail.ru>"> <span class="fn">CTAC</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - =find() returns #NAME?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126491">bug 126491</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;">OS</td>
<td>All
</td>
<td>Mac OS X (All)
</td>
</tr>
<tr>
<td style="text-align:right;">Hardware</td>
<td>All
</td>
<td>x86-64 (AMD64)
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - =find() returns #NAME?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126491#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - =find() returns #NAME?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126491">bug 126491</a>
from <span class="vcard"><a class="email" href="mailto:ctac113@mail.ru" title="CTAC <ctac113@mail.ru>"> <span class="fn">CTAC</span></a>
</span></b>
<pre>I'm using MacOS Mojave 10.14.5 (18F132) and LibreOffice from cask (brew install
libreoffice).
Today I've realised that CALC's spreadsheet substring search function find()
does not work, always returns '#NAME?'
Most updated stable version 6.2.5.2 has same bug too.
Steps to reproduce:
1. Run Libreoffice calc
2. create new spreadsheet
3. type in in any cell: =find('c';'abcdef';2)
4. see #NAME? as result
5. result should be numeric: 3 (or 1, doesn't matter)
6. suppose, that there is error in parameter's order and type
=find('abcdef';'c';2)
7. get #NAME? again
Preferences -> Libreoffice calc -> Formula -> 'Use English function names' does
not affect this result</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>