https://bugs.freedesktop.org/show_bug.cgi?id=59306
Priority: medium
Bug ID: 59306
Assignee: [email protected]
Summary: Calling a table by range-name in VLOOKUP returns #NA
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 72945
--> https://bugs.freedesktop.org/attachment.cgi?id=72945&action=edit
test spreadsheet that reliably demonstrates error/bug.
The attached mini-spreadsheet shows this and several other problems. Here, the
range B15:C38 has been named "TABLE", as can be confirmed by F5. But the call,
in A7, of: VLOOKUP(A3,table,2) returns #N/A, instead of the expected 105. The
same call, with the explicit range B15:C38 in the place of "table", works
correctly.
OO calc, 3.3.0, behaves the same.
LO 3.5.7.2; Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b.
--
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
