Bug 35330

Summary:	Wrong links when saving in Excel XP format
Product:	LibreOffice	Reporter:	paulo.antunespiorla
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE	QA Contact:
Severity:	normal
Priority:	medium	CC:	LibreOffice
Version:	3.3.0 RC4
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:

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 ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.