Bug 104779 - Inconsistent search * character in formula SEARCH
Summary: Inconsistent search * character in formula SEARCH
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-19 12:17 UTC by gmolleda
Modified: 2018-02-18 12:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot with problem SEARCH formula and "*" (178.59 KB, image/png)
2016-12-19 12:17 UTC, gmolleda
Details
ods file with bug (17.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-19 12:19 UTC, gmolleda
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gmolleda 2016-12-19 12:17:08 UTC
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.
Comment 1 gmolleda 2016-12-19 12:19:10 UTC
Created attachment 129776 [details]
ods file with bug
Comment 2 Buovjaga 2016-12-19 19:15:01 UTC
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 :)
Comment 3 gmolleda 2017-01-05 14:50:48 UTC
The solution: regular expression:
=SEARCH("[\*]";...) will use the character * as normal character
Comment 4 gmolleda 2017-02-23 06:49:32 UTC
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.