[Libreoffice-bugs] [Bug 104779] Inconsistent search * character in formula SEARCH

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=104779

Korrawit Pruegsanusak  changed:

   What|Removed |Added

 Attachment #129776|application/octet-stream|application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 104779] Inconsistent search * character in formula SEARCH

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=104779

--- Comment #4 from gmoll...@us.es ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 104779] Inconsistent search * character in formula SEARCH

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=104779

--- Comment #3 from gmoll...@us.es ---
The solution: regular expression:
=SEARCH("[\*]";...) will use the character * as normal character

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 104779] Inconsistent search * character in formula SEARCH

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=104779

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||todven...@suomi24.fi
 Resolution|--- |NOTABUG

--- Comment #2 from Buovjaga  ---
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 :)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 104779] Inconsistent search * character in formula SEARCH

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=104779

--- Comment #1 from gmoll...@us.es ---
Created attachment 129776
  --> https://bugs.documentfoundation.org/attachment.cgi?id=129776=edit
ods file with bug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs