https://bugs.documentfoundation.org/show_bug.cgi?id=142538
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Mike Kaganski <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
