[Libreoffice-bugs] [Bug 142538] EDITING: VLOOKUP function doesn't handle matches with "(", ")" and "/" characters properly

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

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

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.

As mentioned in VLOOKUP help [1], it supports wildcards or regular expressions.
The parentheses are special characters in regular expressions [2] (capturing
parentheses), and thus, when regular expressions are enabled for a spreadsheet
(as is in your sample), treated specially (i.e., "d (e" is an invalid regex,
and "d (e)" matches "d e" and captures "e" in the matched text).

> This behaviour is different this version that old versions of LibreOffice Calc

No. I have checked with LO 6.0.0.3, 5.0.0.5, 4.0.0.3, and 3.3.0.4, as well as
with OOo 3.3.0. They all work identically with your sample.

> it is also different from Excel.

Indeed, because Excel does not support regular expressions in formulas. That's
why in LO 5.2 support for wildcards (a simple matching syntax used by Excel)
was added [3], and in LO 5.3, it was made the default [4].

Maybe your confusion about previous LO versions behaving differently was caused
by working with spreadsheets created in later versions, or with XLS(X), while
now you have opened a file with regex enabled? Or if you are sure that some
older version actually worked differently (which would be a bug in that older
version), you may post this information here.

[1]
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152
[2]
https://unicode-org.github.io/icu/userguide/strings/regexp.html#regular-expression-operators
[3]
https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2
[4] https://wiki.documentfoundation.org/ReleaseNotes/5.3#Option_settings

-- 
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/20210528/7bb92499/attachment.htm>