https://bugs.documentfoundation.org/show_bug.cgi?id=100818
Bug ID: 100818
Summary: add ability to refer to local names in another
worksheet to INDIRECT
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126131
--> https://bugs.documentfoundation.org/attachment.cgi?id=126131&action=edit
test case as described in the bug description
Bug #96915 added the capability to refer to names that are defined in another
worksheet and have local scope there with the normal syntax for names, i.e.
Sheet!Name. Before that, this notation only worked for names either having
local scope in the same worksheet or global names. But what is still missing is
for INDIRECT to deal with this situation too. The attached spreadsheet
"local-name-test.ods" has a local name "pi_value" in Sheet2, and Sheet1
contains one cell refering to with in the formula =Sheet2!pi_value and another
cell with the formula =INDIRECT("Sheet2!pi_value"). In LibreOffice 5.2.0.1 the
first cell works, the second gives a #REF! error. I don’t know Calc well enough
to be certain that there is no other function that would have to be adapted to
deal with references of this kind, so I’d be grateful if whoever gets to work
on this bug could give this some thought. Thank you for fixing Bug #96915 and
for considering this one.
--
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
