Bug 51175 - : Find function reveals error 519 or #WERT! when search element can not be found
Summary: : Find function reveals error 519 or #WERT! when search element can not be found
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-17 10:52 UTC by Axel Mertes
Modified: 2012-06-18 13:44 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 Axel Mertes 2012-06-17 10:52:41 UTC 
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
Comment 1 Regina Henschel 2012-06-18 13:44:09 UTC 
That is the specified behavior. See ODF1.2, part2, section 6.20.9 FIND,
"Returns the character position where Search is first found in T, when the search is started from character position Start. The match is case-sensitive, and no wildcards or other instructions are considered in Search. Returns an Error if text not found."

You could write a request to the OASIS comment list, that a change in the specification is wanted.

The problem has already been reported in issue 38430.