Can I use a remote worksheet range name in a formula?

[GregB]

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.

[oweng]

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

[mariosv]

Hi GregB,

find in this thread information about your question:

Seeking clarification of range name scope in Calc

background ( all sheets in the same file ): one sheet named LECO - with a range name TotalShares defined with scope local one sheet named MDY - with a range name TotalShares defined with scope local one sheet named test - with a range name TotalShares defined with scope local one sheet named SummaryPositions In a formula in the SummaryPositions sheet can I refer to the TotalShares range in the LECO sheet as LECO.TotalShares? When TotalShares was created in the LECO sheet it’s scope …