<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - UNO/Java: cannot retrieve Named Ranges from .ods, but can from .xls/.xlsx"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=94423#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - UNO/Java: cannot retrieve Named Ranges from .ods, but can from .xls/.xlsx"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=94423">bug 94423</a>
from <span class="vcard"><a class="email" href="mailto:pr.nienhuis@hccnet.nl" title="pr.nienhuis@hccnet.nl">pr.nienhuis@hccnet.nl</a>
</span></b>
<pre>A bit of a mixed bag.
The original uploaded files still show no Named range from Octaveusing the Java
UNO bridge (LO 6.3.1).
I made a new .xlsx file in Excel 2013 with 3 named ranges, here the named
ranges show up in Octave.
Then I converted that to .ods => Named ranges show up in Octave.
I made a new .ods file with 2 named ranges => Octave cannot show them.
Converted it to .xlsx uing LO 6.1.3 ==> Octave can't find the named ranges.
Converted it to .xlsx using Excel 2013 => shows just 1 named range in Excel
(see attached pic) but no named ranges at all in octave.
I'd say it is beginning to get better :-)
Then I made another .ods file with named ranges, and Excel doesn't like the
.ods file. After allowing Exel to "repair" the file excel mentions it removed
illegal content in /xl/tables/table2.xml part (Table 2)". Ominous.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>