https://bugs.freedesktop.org/show_bug.cgi?id=51175
Bug #: 51175
Summary: : Find function reveals error 519 or #WERT! when
search element can not be found
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: axel.mer...@magnamana.com
Problem description:
Steps to reproduce:
1. Enter A1="Test"
2. Enter B1=FINDEN("x";A1;1)
Result is #WERT! (or Error #519 if I am correct).
It should be 0 or -1 or something meaningfull we can process, but not an error
that can not be handled. I Excel this works correct, and I believe in
OpenOffice too.
3. Enter B1=FINDEN("e";A1;1)
Result is "2" which is correct.
Current behavior:
Error 519 or #WERT!
Expected behavior:
0 or -1 (FALSE)
Platform (if different from the browser):
Windows 7 x64
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:13.0) Gecko/20100101
Firefox/13.0
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
