[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 #6 from pr.nienhuis at hccnet.nl ---
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.

-- 
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/20181127/d6de927e/attachment.html>