[Libreoffice-bugs] [Bug 126491] =find() returns #NAME?

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126491

CTAC <ctac113 at mail.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|All                         |Mac OS X (All)
           Hardware|All                         |x86-64 (AMD64)

--- Comment #1 from CTAC <ctac113 at mail.ru> ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190721/f321a1ec/attachment-0001.html>