Bug 126491 - =find() returns #NAME?
Summary: =find() returns #NAME?
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.4.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-07-21 06:01 UTC by CTAC
Modified: 2019-07-21 14:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description CTAC 2019-07-21 06:01:26 UTC 
CALC Find() function for substring search returns #NAME?
Comment 1 CTAC 2019-07-21 06:13:40 UTC 
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
Comment 2 MM 2019-07-21 08:12:23 UTC 
When using " instead of ' it works.
Comment 3 CTAC 2019-07-21 08:20:16 UTC 
Yes! sorry to disturb you, guys!