Created attachment 129775 [details] 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.
Created attachment 129776 [details] ods file with bug
See my recent answer to an almost identical problem: https://bugs.documentfoundation.org/show_bug.cgi?id=104776#c2 You would have to use SUBSTITUTE. Please do searches, also on ask.libreoffice.org.. if there is still something hazy, you can try to ask on ask.libreoffice.org. Bugzilla is not a support forum, I hope you understand :)
The solution: regular expression: =SEARCH("[\*]";...) will use the character * as normal character
The problem for me was that I did not know the option of tools to use or not regular expressions and I had it marked. Depending on the choice of using wildcards or using regular expressions, the function behaves exactly like Excel or with regular expressions. It is perfect. El problema para mi fue que yo desconocía la opción de herramientas para usar o no expresiones regulares y yo la tenía marcada. Según esté elegida la opción de usar comodines o usar expresiones regulares la función se comporta exactamente igual que Excel o con expresiones regulares. Es perfecto. La problemo por mi estis ke mi ne sciis pri la iloj por uzi regulajn esprimojn kaj mi eblis ĝin. Se vi elektas uzi ĵokerojn aŭ regulajn esprimojn la funkcio kondutas precize kiel Excel aŭ kun regulaj esprimoj. Ĉio estas perfekta.