https://bugs.freedesktop.org/show_bug.cgi?id=88581
Bug ID: 88581
Summary: VLOOKUP returns #N/A
Product: LibreOffice
Version: 4.4.0.2 rc
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 112459
--> https://bugs.freedesktop.org/attachment.cgi?id=112459&action=edit
test ODS file
VLOOKUP returns #N/A in the attached spreadsheet. The expected return value is
"1".
Steps to reproduce:
1. Open the attached ODS file;
2. Observe that cell B2 has formula "=VLOOKUP(A2,E1:F1,2,0)". A2 contains
string "26*12-12-8 TL R1".
Expected:
Because Cell E1 contains the string "26*12-12-8 TL R1" to be lookup, so cell B2
should return "1" (cell F1)
Current Behaviour:
Cell B2 returns "#N/A".
Win 7 X86
Version: 4.4.0.2
Build ID: a3603970151a6ae2596acd62b70112f4d376b990
Locale: zh_CN
VLOOKUP is one of the most common used functions in spreadsheet, so this is a
critical issue.
--
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
