| Summary: | VLOOKUP returns err 504 with another file | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | GerardF <gerard.fargeot> |
| Component: | LibreOffice | Assignee: | Kohei Yoshida <kohei> |
| Status: | CLOSED FIXED | ||
| Severity: | critical | CC: | sophi |
| Priority: | high | ||
| Version: | unspecified | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| Whiteboard: | target:3.3 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | 2 spreadsheets in the zip | ||
Ok. Luckily a fix was very simple. Hopefully fixed for the next 3.3 build. Verified - Closed - Sophie |
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