[Libreoffice-bugs] [Bug 94423] UNO/Java: cannot retrieve Named Ranges from .ods, but can from .xls/.xlsx

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=94423

--- Comment #16 from pr.nienhuis at hccnet.nl ---
@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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200428/861b4420/attachment.htm>