<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - UNO/Java: cannot retrieve Named Ranges from .ods, but can from .xls/.xlsx"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=94423#c16">Comment # 16</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - 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>@Buovjaga:
Hang on, I gave you a wrong Octave command for reading the file, sorry.
The spreadsheet I/O interface was missing (Octave has several "interfaces"
(dependencies) to choose from for reading spreadsheets).
It should read:
[a, b, c, d] = xlsfinfo ("/home/tonttu/user/range_tst.ods", "uno")
Using that the Octave code seems to read the Named ranges well, but only the
second try. The first time Java emits a warning about "An illegal reflective
access operation" and no name ranges are read then.
It could well be that 5 years ago this also happened but w/o the Java warning
so it looked like an upstream bug (from Octave's perspective). I do remember
starting to see that Java warning intermittently after I upgraded Java on my
Windows boxes from 8 to 10 some time ago; so this may be a concealed bug in
Octave's Java subsystem that got somewhat more clearly exposed by a newer Java
release.
I'll enter a bug report for Octave.
All in all I think this bug report can be closed as "invalid" or the like.
Thanks.</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>