https://bugs.freedesktop.org/show_bug.cgi?id=74948
Priority: medium
Bug ID: 74948
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: VLOOKUP has problems accessing data from another file
when SortOrder is 0
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: john32...@gmail.com
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 94020
--> https://bugs.freedesktop.org/attachment.cgi?id=94020&action=edit
VLOOKUP Main file
Using VLOOKUP when the array is in the same file works OK (error messages when
expected). If the array is in a separate file, works OK when SortOrder is 1,
when SortOrder is 0, result is always "#N/A" or "Error: Value not available".
VLOOKUP worked OK on previous versions of LibreOffice.
The attached file illustrates the values expected.
If the lower part of the file is saved into another file, the results are OK
when SortOrder is 1; however when SortOrder is 0, VLOOKUP fails.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
