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

>> javaclasspath
   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
:
:
>>

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:

>> [a, b, c, d] = xlsfinfo ("TrialRange.xlsx")
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)

>> [a, b, c, d] = xlsfinfo ("TrialRange_ods.ods")
fformat = ODSWorkbook
a = OpenOffice.org Calc spreadsheet
b =
{
  [1,1] = Sheet1
  [1,2] = A1:B4
}

c = ODSWorkbook
d = {}(0x3)
>>

where struct variable d (containing Named range info) is empty.

-- 
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/6c580180/attachment.htm>