<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Named ranges without sheet reference are exported as corrupted XLSX" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113991#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Named ranges without sheet reference are exported as corrupted XLSX" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113991">bug 113991</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>