<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ilmari.lauhakangas@libreoffice.org" title="Buovjaga <ilmari.lauhakangas@libreoffice.org>"> <span class="fn">Buovjaga</span></a>
</span> changed
<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>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<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#c15">Comment # 15</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:ilmari.lauhakangas@libreoffice.org" title="Buovjaga <ilmari.lauhakangas@libreoffice.org>"> <span class="fn">Buovjaga</span></a>
</span></b>
<pre>Thanks, I confirm with <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=132140" name="attach_132140" title="simple .ods file with 2 sheets and 3 named ranges">attachment 132140</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132140&action=edit" title="simple .ods file with 2 sheets and 3 named ranges">[details]</a></span>:
[a, b, c, d] = xlsfinfo ("/home/tonttu/user/range_tst.ods")
fformat = ODSWorkbook
a = OpenOffice.org Calc spreadsheet
b =
{
[1,1] = Blad1
[2,1] = blad2
[1,2] = B3:C5
[2,2] = B7:D9
}
c = ODSWorkbook
d = {}(0x3)
For my notes, adding the paths on Linux:
javaaddpath ('/usr/lib/libreoffice/program/classes/ridl.jar')
javaaddpath ('/usr/lib/libreoffice/program/classes/unoloader.jar')
javaaddpath ('/usr/lib/libreoffice/program/classes/juh.jar')
javaaddpath ('/usr/lib/libreoffice/program/classes/jurt.jar')
javaaddpath ('/usr/lib/libreoffice/program/classes/unoil.jar')
javaaddpath ('/usr/lib/libreoffice/program')
Arch Linux 64-bit
Version: 6.4.3.2
Build ID: 6.4.3-1
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5;
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded</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>