Download it now!
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

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