Bug 114388 - SEARCH function fails (#VALUE!) if search string is longer than text
Summary: SEARCH function fails (#VALUE!) if search string is longer than text
Status: CLOSED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Eike Rathke
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-10 16:55 UTC by Eike Rathke
Modified: 2017-12-10 17:18 UTC (History)
0 users

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 Eike Rathke 2017-12-10 16:55:27 UTC 
The SEARCH function fails returning a #VALUE! result if the search string is longer than the text to be searched, which is valid if wildcards or regular expressions are active. For example:
SEARCH("word","^word.*")
should return 1.
Comment 1 Eike Rathke 2017-12-10 16:55:56 UTC 
Taking.
Comment 2 Eike Rathke 2017-12-10 17:13:15 UTC 
Of course the example should be SEARCH("^word.*","word") ...
Comment 3 Eike Rathke 2017-12-10 17:18:29 UTC 
And therefor this case is nonsense..