Bug 35330

Summary:	Wrong links when saving in Excel XP format
Product:	LibreOffice	Reporter:	paulo.antunespiorla
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	LibreOffice
Priority:	medium
Version:	3.3.0 RC4
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description paulo.antunespiorla 2011-03-15 06:11:31 UTC

In Calc, when we use the functio VLOOKUP, exemple: =VLOOKUP(A1686;'file:///Y:artigos.xls'#$Sheet2.A$2:D$7922;4;FALSE()) and save as Microsoft Excel 97/200/XP (.xls), the next time that we open that file .xls, we most decide to update or not the file because the file contains links to other files, but in cell, we have the error message Err:502, because the array function is not correct, the same exemple open after save as .xls: =VLOOKUP(A1686;'file:///Y:artigos.xls'#$''.A$2:D$7922;4;FALSE())

Comment 1 Rainer Bielefeld Retired 2011-03-15 09:31:12 UTC

This one is a DUP of
Bug 32717 - Wrong cell links when saving in Excel XP format

@paulo.antunespiorla@gmail.com
Thank you for your attention!

Can you please try to find more meaningful summaries? Hints on 
<http://wiki.documentfoundation.org/BugReport>
might be useful for you!

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