[Libreoffice-bugs] [Bug 113991] Named ranges without sheet reference are exported as corrupted XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
An omitted sheet reference means an implicit relative "same sheet where used"
reference, something Excel doesn't seem to know in named expressions. I think
there's only this solution:
* if the named expression is in sheet-local scope, add the absolute
  sheet self-reference to such references
* if it is in global scope, create a sheet-local expression for each
  sheet and add the absolute sheet self-reference (effectively that's
  how a global expression with a relative sheet self-reference works)
  * if there is a name clash omit creating such a named expression
    because any formula using the name on that sheet was already using
    the sheet-local expression

-- 
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/20171122/b15fc41f/attachment.html>