https://bugs.documentfoundation.org/show_bug.cgi?id=92912
Bug ID: 92912
Summary: EDITING: Not possible to reference a named range in
another sheet
Product: LibreOffice
Version: 4.4.4.3 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 117416
--> https://bugs.documentfoundation.org/attachment.cgi?id=117416&action=edit
Demonstrate cross-sheet named references not working
This bug is mentioned in
https://bugs.documentfoundation.org/show_bug.cgi?id=82135, and I'm posting it
as a separate report as requested.
Imported Excel 2007 spreadsheets that contains a formula that refers to a named
range on another sheet of the same workbook display a zero value or #NAME?
error.
In the attached Excel file, cell A1 on sheet2 contains the value 123. That cell
is named 'namedthing' and is listed in the named ranges manager. Cell A1 on
sheet1 contains a formula that refers to it: "='sheet2'!namedthing". On opening
the file, instead of showing the referenced value, it shows a 0 (which may be a
symptom of the above linked bug). If I edit the formula, delete the last char
and retype it (i.e. not changing it), it changes to a #NAME? error.
If I choose insert -> names -> insert... I can see it defines the name,
including which sheet it is defined on, but selecting that inserts only an
unqualified name reference (just "namedthing") which does not resolve on
sheet1.
I don't know if this is specific to Excel imports, but I couldn't find any
working syntax for cross-sheet named references, for example while
"=$sheet1.A1" works, "=$sheet1.namedthing" does not. I also note that the Excel
import does not convert references from single-quotes and ! to $ and . syntax.
I assume this is supposed to work?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
