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 ")
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.