<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#c13">Comment # 13</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>@Myk Dowling:
That just isn't enough by itself. Reading with Excel shows all Named ranges.
The bug is in the UNO-Java bridge, where they don't show up. Does Google Docs
invoke the UNO-Java bridge?
@Buovjaga:
Octave needs the LO6 Java jars + program dir in the javaclasspath to avoid the
ClassNotFoundException.
Use Octave's
javaaddpath ('/full/path/to/<name_of>.jar') and/or
javaaddpath ('/full/path/to/subdir')
to add them one by one to the javaclasspath. FYI, mine looks as follows w.r.t.
the LO6 Java .jars:
<span class="quote">>> javaclasspath</span >
STATIC JAVA PATH
- empty -
DYNAMIC JAVA PATH
C:\Program Files\LibreOffice\program\classes\ridl.jar
C:\Program Files\LibreOffice\program\classes\unoloader.jar
C:\Program Files\LibreOffice\program\classes\juh.jar
C:\Program Files\LibreOffice\program\classes\jurt.jar
C:\Program Files\LibreOffice\program\classes\unoil.jar
C:\Program Files\LibreOffice\program
:
:
<span class="quote">>></span >
Furthermore Octave need the io package installed and loaded.
pkg install -forge io ## to install the io package
pkg load io ## to load the io package
Then dos/th along the lines of:
[a, b, c, d] = xlsfinfo ("<ods file>.ods")
and if all is well you'll get s/th like:
<span class="quote">>> [a, b, c, d] = xlsfinfo ("TrialRange.xlsx")</span >
a = Microsoft Excel Spreadsheet
b =
{
[1,1] = Sheet1
[1,2] = A1:B4
}
c = xlOpenXMLWorkbook
d =
{
[1,1] = TrialRange
[1,2] = Sheet1
[1,3] = A1:B3
}
BUT (and there's the bug)
<span class="quote">>> [a, b, c, d] = xlsfinfo ("TrialRange_ods.ods")</span >
fformat = ODSWorkbook
a = OpenOffice.org Calc spreadsheet
b =
{
[1,1] = Sheet1
[1,2] = A1:B4
}
c = ODSWorkbook
d = {}(0x3)
<span class="quote">>></span >
where struct variable d (containing Named range info) is empty.</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>