https://bugs.documentfoundation.org/show_bug.cgi?id=146470
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Mike Kaganski <[email protected]> --- This is not a bug. As explained in VLOOKUP documentation [1], the function supports regular expressions if enabled in the spreadsheet options. Your spreadsheet does enable regular expressions. Your strings include parentheses; and parentheses have special meaning in regular expressions (which your B3 is considered to be by VLOOKUP). So searching for regular expression "PORTAALI_SME_FI_101 (N2003361)" means searching for text "PORTAALI_SME_FI_101 N2003361" (note no parentheses), and using the last part as a group (e.g., for purposes of backreferencing it). The text in that form indeed does not exist in the search range. Either disable regular expressions, or use workarounds mentioned in the help article, that allow to disable treating characters as special regex expressions. [1] https://help.libreoffice.org/7.3/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 -- You are receiving this mail because: You are the assignee for the bug.
