Bug 125134

Summary: Not possible to use named ranges in external spreadsheet
Product: LibreOffice Reporter: Balvie <rene>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: miguelangelrv, oliver.brinzing, raal
Priority: medium    
Version: 6.2.3.2 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: named range pointing to another spreadsheet

Description Balvie 2019-05-06 12:49:51 UTC 
I have problems doing a vlookup in an external sheet.

Up to now I need to refer as:
VLOOKUP(C15,'file:///C:/.....ods'#$pricelist.$B$10:$D$82,2,0))
and the price as:
VLOOKUP(C15,'file:///C:/.....ods'#$pricelist.$B$10:$D$82,3,0))

I'd like to use a named range for this, something like:
VLOOKUP(C15,'file:///C:/.....ods'#pricetable,2,0))
VLOOKUP(C15,'file:///C:/.....ods'#pricetable,3,0))

I would expect that this should be possible. Is there something I have missed?

Is there any documentation about the scope and precise syntax of using a named range?
Comment 1 Oliver Brinzing 2019-05-06 17:05:42 UTC 
Created attachment 151208 [details]
named range pointing to another spreadsheet

i don't think, this is possible.
but you can create a named range pointing to another sheets
Comment 2 raal 2019-05-07 17:11:20 UTC 
Not possible  -  see bug 60170
Comment 3 m_a_riosv 2019-05-07 20:22:09 UTC 
But seems a dup of tdf#72594

*** This bug has been marked as a duplicate of bug 72594 ***
Comment 4 Balvie 2019-05-08 20:09:02 UTC 
Now that it is explained, its clear for me how it works. The method of a named range created in the local file is okay for me.
Issue may be closed (do not know how to do that).
Thanks for helping and answering.