We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Can I use a remote worksheet range name in a formula? [closed]

asked 2013-05-12 02:02:09 +0200

GregB gravatar image

updated 2020-08-07 20:23:04 +0200

Alex Kemp gravatar image


In LO Build ID: 350m1(Build:2) on ubuntu 10.04, I am trying to build a formula including a reference to a named range on a sheet in another .ods file. The named range is scoped to the sheet rather than to the workbook. What syntax will let me use the name in my formula? For example, I expect it would look something like this:


Is there some way to have LO recognise/suggest the range name and/or replace a reference to an explicit cell range with the corresponding reference to the named range?

Thank you.

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 2016-02-25 18:14:44.032231

2 Answers

Sort by » oldest newest most voted

answered 2013-05-12 02:47:09 +0200

oweng gravatar image

updated 2013-05-19 04:48:50 +0200

The form for external Calc range explicit references is:


Unfortunately though there appears to be a lack of support within the ODF specification for saving external range name references (FDO#60170). Local ranges would likely look like this:


Global ranges would likely look like this:


Currently there is no way to select or obtain a valid range name for an external Calc file. Note also, that the v3.x series do not suffer from a related problem with external references that affects the v4.0 series (FDO#64229).

edit flag offensive delete link more

answered 2013-05-12 02:59:40 +0200

m.a.riosv gravatar image

Hi GregB,

find in this thread information about your question:

edit flag offensive delete link more

Question Tools


Asked: 2013-05-12 02:02:09 +0200

Seen: 1,416 times

Last updated: Jun 16 '14