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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
