Bug 74948 - VLOOKUP has problems accessing data from another file when SortOrder is 0
Summary: VLOOKUP has problems accessing data from another file when SortOrder is 0
Status: RESOLVED DUPLICATE of bug 72041
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-13 19:32 UTC by John
Modified: 2014-10-12 09:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
VLOOKUP Main file (43.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-13 19:32 UTC, John 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description John 2014-02-13 19:32:57 UTC 
Created attachment 94020 [details]
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.
Comment 1 m_a_riosv 2014-02-13 21:14:56 UTC 
Hi John, thanks for reporting.

I think it is a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=72041.

Please if you are not agree, reopen it.

*** This bug has been marked as a duplicate of bug 72041 ***