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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
