https://bugs.documentfoundation.org/show_bug.cgi?id=126491
CTAC <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|All |Mac OS X (All)
Hardware|All |x86-64 (AMD64)
--- Comment #1 from CTAC <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
