https://bugs.freedesktop.org/show_bug.cgi?id=82261
Priority: medium
Bug ID: 82261
Assignee: [email protected]
Summary: Other: Vlookup/Match formulas don't work when search
criterion contains "()" parentheses
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 104172
--> https://bugs.freedesktop.org/attachment.cgi?id=104172&action=edit
weird answer for vlookup formula when range contains "()"
Problem description:
"Vlookup" and "Match" formulas don't work when data range contains "()"
caracters.
Steps to reproduce:
1. A1="(a)"; A2="b"
2. B2="(a)"; B2="=VLOOKUP(A2;$A$1:$B$1;2;0)"
Current behavior:
B2=#N/A
Expected behavior:
B2="b"
Operating System: Ubuntu
Version: 4.2.4.2 release
--
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
