Ask Your Question
0

INDIRECT and named ranges in another file [closed]

asked 2013-05-18 19:04:34 +0200

scott-douglass gravatar image

updated 2015-11-01 12:59:43 +0200

Alex Kemp gravatar image

I want to use INDIRECT to access a cell from another spreadsheet by name. For example, if "xyz" is a global name for A1 in "file%20b.ods" I expect this formula to work:

=INDIRECT("'file:///path-to/file%20b.ods'#xyz")

but I just get #REF. Am I doing something wrong? (Of course I'm actually using the real path.)

This works:

='file:///path-to/file%20b.ods'#xyz

But that isn't powerful enough because I need to use an expression to produce the name.

I'm using 4.0.3.3 on Mac OS X 10.8.3. I thought that it was working before 4.0.3, but I can't reproduce it working in 3.6.4, so I may be thinking of a different case.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-01 12:59:59.341312

1 Answer

Sort by » oldest newest most voted
0

answered 2013-05-19 02:08:49 +0200

m.a.riosv gravatar image

updated 2013-05-19 02:11:37 +0200

After some tries I think it is a bug.
Reported bug:
EDITING: INDIRECT() function does not work linking range names in another file

edit flag offensive delete link more

Comments

Does fdo#60170 block this new bug? No. Sorry, I don't think it does on re-reading, as it seems related to import/export to/from ODF rather than the native save.

oweng gravatar imageoweng ( 2013-05-19 04:51:09 +0200 )edit

Question Tools

Stats

Asked: 2013-05-18 19:04:34 +0200

Seen: 639 times

Last updated: May 19 '13