Bug 64747

Summary:	EDITING: INDIRECT() function does not work linking range names in another file
Product:	LibreOffice	Reporter:	m.a.riosv <mariosv>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	jmadero.dev
Version:	4.0.3.3 release
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:

Description m.a.riosv 2013-05-19 00:06:46 UTC

From a question in Ask:
http://ask.libreoffice.org/en/question/17677/indirect-and-named-ranges-in-another-file/

Win7x64 Ultimate.
Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539)

- Created a link to another file with range name, works as expected.
=+'file:///C:/Users/_Test/Untitled1.ods'#Range

- The same link inside INDIRECT() function does not work.
=INDIRECT("'file:///C:/Users/_Test/Untitled1.ods'#Range
")

Comment 1 Joel Madero 2014-05-05 03:54:31 UTC

Thank you for reporting this issue! I have been able to confirm the issue on:
Version: 4.3.0.0.alpha0
Date:   Thu Apr 24 21:43:16 2014 +0300
Platform :Ubuntu 14.04
DE: GNOME3

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
As I've been able to confirm this problem I am marking as:

New (confirmed)
Normal - can prevent professional quality work
Medium - default seems appropriate

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material

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.