https://bugs.documentfoundation.org/show_bug.cgi?id=96915
Bug ID: 96915
Summary: add ability to refer to local names in another
worksheet
Product: LibreOffice
Version: 5.0.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If a name is defined with worksheet scope, there still are valid use cases
where another worksheet needs to refer to that name. My example is a
spreadsheet document that contains monthly recurring calculations, each in
similarly structured worksheets that define and use equally named cells. To
make this work, the names need to be defined with worksheet scope. The document
also contains an overview worksheet that sums up values from named cells across
the worksheets. The clearest way to achieve this is to refer to these cells via
their names. In Excel this is perfectly possible: the reference syntax is to
combine the sheet name, an exclamation mark, and the name defined in that
worksheet. Creating such a file in Excel and then opening it in LibreOffice
will produce #REF errors.
Solution: make the formula engine treat references of the form sheet!name
(where "name" is not a cell or range reference in the currently active [A1 or
R1C1] syntax) to resolve the name "name" as it would do in the worksheet
"sheet", even if the reference appears in a different worksheeet.
--
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
