https://bugs.freedesktop.org/show_bug.cgi?id=71998
Priority: medium
Bug ID: 71998
Assignee: [email protected]
Summary: Vlookup not working when paren in lookup field
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.4.2 release
Component: Spreadsheet
Product: LibreOffice
Steps to reproduce:
- in A1, input "a("
- in A2, input "1"
- in C1, input "a("
- in C2, input "=VLOOKUP(C1, A1:A2, 2, 0)"
Expected: C2 evaluates to "1"
Actual: C2 evaluates to #N/A
Reproduces every time. The vlookup works fine without the ( in A1 and C1.
--
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
