| Summary: | SEARCH function fails (#VALUE!) if search string is longer than text | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Eike Rathke <erack> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | CLOSED INVALID | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
Taking. Of course the example should be SEARCH("^word.*","word") ...
And therefor this case is nonsense.. |
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.