[Libreoffice-bugs] [Bug 125134] New: Not possible to use named ranges in external spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125134

            Bug ID: 125134
           Summary: Not possible to use named ranges in external
                    spreadsheet
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rene at balvers.nl

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?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190506/2b6f9e29/attachment.html>