https://bugs.documentfoundation.org/show_bug.cgi?id=93305
Bug ID: 93305
Summary: vlookup comparison operator confused by strings
containing parentheses
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 117794
--> https://bugs.documentfoundation.org/attachment.cgi?id=117794&action=edit
example of vlookup being confused when comparison string contains parentheses.
Strings like "16GB (2x8GB) 1600MHz DDR3L [add $112.00]" confuse vlookup.
The above string is used in the description of a product and so I copied it
into one column and put the price in the next column. In another sheet one
column is validated to contain the values from the above column. Using vlookup
it should put the price next to it. However the vlookup does not find the
description if it contains a parentheses like in the "(2x8GB)" above.
I've attached a file showing the problem.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
