[Libreoffice-bugs] [Bug 139832] function vpr doesn't show results if i use round brackets

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.
In your ODS document, you have regular expressions enabled in formulas [1]. As
VLOOKUP documentation tells [2]:

> The search supports wildcards or regular expressions.
> ...
> You can switch the automatic evaluation of wildcards or regular expression
> on and off in Tools - Options - LibreOffice Calc - Calculate.

Brackets have special meaning in regular expressions [3]. So with regular
expressions enabled, search for string "Детские продукты (Акушерство)" actually
tries to find text "Детские продукты Акушерство", and would make "Акушерство" a
referenceable entity (not what you obviously expect).

Excel (and its formats) do not support regular expressions, thus saving in its
formats would disable regular expressions in its files. But with ODS, which
supports all modes fully, if you don't need regular expressions, you need to
make proper settings.

Note that in later versions of LibreOffice, regular expressions are not enabled
by default, partially to avoid newbies making this mistake.

Closing NOTABUG.

[1]
https://help.libreoffice.org/7.1/en-US/text/shared/optionen/01060500.html#bm_id3154419
[2]
https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152
[3] https://help.libreoffice.org/7.1/en-US/text/shared/01/02100001.html

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210122/395a7f46/attachment-0001.htm>