https://bugs.documentfoundation.org/show_bug.cgi?id=113991
--- Comment #2 from Eike Rathke <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
