Bug 31718 - VLOOKUP returns err 504 with another file
Summary: VLOOKUP returns err 504 with another file
Status: CLOSED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86 (IA32) Windows (All)
: high critical
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.3
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-18 05:26 UTC by GerardF
Modified: 2011-01-12 07:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
2 spreadsheets in the zip (19.26 KB, application/x-zip-compressed)
2010-11-18 05:26 UTC, GerardF 		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 GerardF 2010-11-18 05:26:57 UTC 
Created attachment 40376 [details]
2 spreadsheets in the zip

VLOOKUP with external datarange don't work.

Attachment :
File 1 : Array.ods contains data
File 2 : Vlookup.ods contains formula searching data in File 1

=VLOOKUP(A2;'file:///c:/users/<username>/documents/array.ods'#$feuille1.A3:B15;2)

Returns Erreur 504

LibreOffice 3.3.0 
OOO330m12 (Build:2)
libreoffice-build 3.2.99.3
Comment 1 Kohei Yoshida 2010-11-18 10:53:04 UTC 
Ok.  Luckily a fix was very simple.

Hopefully fixed for the next 3.3 build.
Comment 2 sophie 2011-01-12 07:49:38 UTC 
Verified - Closed - Sophie