[Libreoffice-bugs] [Bug 142538] New: 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

            Bug ID: 142538
           Summary: EDITING: VLOOKUP function doesn't handle matches with
                    "(", ")" and "/" characters properly
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: simonwerner at gmail.com

Created attachment 172402
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172402&action=edit
Example of VLOOKUP bug

The VLOOKUP behaves incorrectly in v7.1.3.2.  If you are looking up the value
"d (e)" in a column, it will not match a cell with the same value.

For example, if you are looking up "d (e)" using '=VLOOKUP("d
(e)",A:A,1,FALSE)' in a column with the following values:
"a"
"b"
"c"
"d e"
"d (e"
"d (e)"

it will match on "d e", this in correct, it should match "d (e)".

This behaviour is different this version that old versions of LibreOffice Calc,
it is also different from Excel.

This occurs on Ubuntu 21.04 with the default LibreOffice 7.1.3.2 installed. 
Attached is an example spreadsheet.

-- 
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/75836c6f/attachment.htm>