<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING: Data validity produces empty drop list for a named cell range" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124307#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING: Data validity produces empty drop list for a named cell range" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124307">bug 124307</a> from <a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> Oliver Brinzing</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150259" name="attach_150259" title="simple test case created with excel 2016">attachment 150259</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150259&action=edit" title="simple test case created with excel 2016">[details]</a> simple test case created with excel 2016 created a simple test case with ms excel 2016: LO will import a *.xlxs spreadsheet with global named range: =Tabelle1!$A$1:$A$3 to $Tabelle1.$A$1:$A$3. and will export "global" named range "Sheet2.$A$1:Sheet2.$A$4" (defined on Sheet1) to "Sheet1!$A$1:$A$3" steps to reproduce: - open *.ods attachment "simple testcase" <a href="https://bugs.documentfoundation.org/attachment.cgi?id=150256">https://bugs.documentfoundation.org/attachment.cgi?id=150256</a> - save as *.xlsx - open with excel - Sheet2.B5 dropdown list now displays values from cell range: Sheet1!$A$1:$A$3</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>