Bug 85515

Summary:	Linking Calc Data - Referencing other documents ERROR
Product:	LibreOffice	Reporter:	blargh
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG	QA Contact:
Severity:	normal
Priority:	medium	CC:	blargh, mariosv
Version:	4.3.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:

Description blargh 2014-10-27 13:25:23 UTC

Problem description: 
When linking Calc data by referencing other documents using =’file:///Path & File Name’#$SheetName.CellName , sometimes (not always!) the link only works if the linked file is open. The link is then lost when the linked file is closed, and a #N/A error is shown in the cell with the link.

Steps to reproduce:
1. Create a file with numerical/text/time values.
2. Create a second file with references to the values in the first file (=’file:///Path & File Name’#$SheetName.CellName)
3. Close the first file and check the links in the second file.

Current behavior:
Some links give an #N/A error when the linked file is closed.

Expected behavior:
All the links should work all the time, even if the linked files are closed.

Comment 1 m.a.riosv 2014-10-27 22:26:52 UTC

Hello @blargh,

Thank you for reporting the bug. Please attach a sample files, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

Comment 2 blargh 2014-10-29 17:59:44 UTC

Hi m.a.riosv,

I think we can marked this bug as RESOLVED.
From what I could assess, the problem was in the referenced files I was trying to access using =’file:///Path & File Name’#$SheetName.CellName . Some of the cells in the referenced files were accessible after the file was closed, while others became #N/A. However, making new referenced files from scratch solves the problem..

Shouldn't have rushed reporting this "bug".

Thanks anyway and
all the best,
Pedro

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.