Ask Your Question
1

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

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

GregB gravatar image

updated 2015-09-04 17:10:24 +0200

Alex Kemp gravatar image

Hello,

In LO 3.5.7.2 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:

=Sum('path_filename'#'sheetname'$named_range)

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
1

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:

'file:///path/to/file.ods'#Sheet1.A1:A3

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:

'file:///path/to/file.ods'#Sheet1.range_name

Global ranges would likely look like this:

'file:///path/to/file.ods'#range_name

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
0

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

m.a.riosv gravatar image

Hi GregB,

find in this thread information about your question:
http://ask.libreoffice.org/en/question/1362/seeking-clarification-of-range-name-scope-in-calc/

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 970 times

Last updated: Jun 16 '14