https://bugs.documentfoundation.org/show_bug.cgi?id=104779
Bug ID: 104779
Summary: Inconsistent search * character in formula SEARCH
Product: LibreOffice
Version: 5.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 129775
--> https://bugs.documentfoundation.org/attachment.cgi?id=129775&action=edit
Screenshot with problem SEARCH formula and "*"
The function SEARCH use "*" like wildcard, but What is the scape character?
The function FIND use "*" like normal character. That is inconsistent.
Two errors: inconsistent behaviour SEARCH - FIND, and How I could search the
normal character "*" in SEARCH formula.
In Excel the behaviour is identical inconsistent, BUT in Excel I can use the
scape character ~ before *: =SEARCH("~*";...) search the normal character *
Attach screenshot with example.
--
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
