Hi Steph,
Take note of my comments between chk_spreadsheet_support's output...
Steph Bredenhann wrote:
> As reported previously the symlink didn't work so I have implemented
> the hack as suggested by Michael and recompiled the JAVA package.
Good on you! IIRC you claimed about being a "novice"? ;-)
> I have now made some progress! However, I still can't read the .ods file
>
> The result of the chk_spreadsheet_support is now:
>
> chk_spreadsheet_support ('/usr/lib/java/',3)
>
> Checking Excel/ActiveX/COM... not working.
>
> Checking Java support...
> 1. Checking Java JRE presence.... OK, found one.
> 2. Checking Octave Java support... Java package seems to work OK.
> Java (version 1.6.0_24) seems OK.
> Maximum JVM memory: 1780 MiB; sufficient.
This value (1780 MiB) is HUGE. But as long as it works OK.... (you have
a 64bit machine, it's just that I'm not used to such big numbers yet on
my 32bit boxen)
> Java support OK
Good. Java works.
> Checking javaclasspath for .jar class libraries needed for spreadsheet
> I/O...:
>
> Basic POI (.xls) <poi-3> <poi-ooxml>:
> poi-3....jar missing
> poi-ooxml-3....jar missing
> => Not all classes (.jar) required for POI in classpath
>
> POI OOXML (.xlsx) <xbean> <poi-ooxml-schemas> <dom4j>:
> xbean....jar missing
> poi-ooxml-schemas....jar missing
> dom4j-1.6.1....jar missing
> => Some classes for POI OOXML support missing
>
> JExcelAPI (.xls (incl. BIFF5 read)) <jxl>:
> jxl....jar missing
> => Not all classes (.jar) required for JXL in classpath
>
> OpenXLS (.xls (BIFF8)) <OpenXLS>:
> OpenXLS....jar missing
> => Not all classes (.jar) required for OXS in classpath
>
> ODF Toolkit (.ods) <odfdom> <xercesImpl>:
> - /usr/lib/java/odfdom-java-0.8.7.jar OK
> - /usr/lib/java/xerces-2_11_0/xercesImpl.jar OK
> => ODFtoolkit (OTK) OK.
This ^^^^^^^^ means you *do* have ODS support using OTK interface.
> jOpenDocument (.ods + experimental .sxc readonly) <jOpendocument>:
> jOpenDocument....jar missing
> => Not all required classes (.jar) in classpath for JOD
>
> UNO/Java (.ods, .xls, .xlsx, .sxc) <OpenOffice.org>:
> program.... (directory) not found
> unoil....jar missing
> jurt....jar missing
> juh....jar missing
> unoloader....jar missing
> ridl....jar missing
> => One or more UNO classes (.jar) missing in javaclasspath
> Some class libs lacking yet...
>
> Trying to add missing java class libs to javaclasspath...
> ? poi-3<...>.jar ?
> ? poi-ooxml-3<...>.jar ?
> ? xbean<...>.jar ?
> ? poi-ooxml-schemas<...>.jar ?
> ? dom4j-1.6.1<...>.jar ?
> ? jxl<...>.jar ?
> ? OpenXLS<...>.jar ?
> ? jOpenDocument<...>.jar ?
> Some other class libs still lacking...
xhk_spreadsheet_support.m can't find Excel support jars, nor
jOpenDocument jar.
But it did say you have all jars needed for OTK in your javaclasspath.
> ans = 32
This is a bit flag indicating which interfaces are supported.
Again, this value means you *do* have ODS support using OTK interface.
>
>
> Any suggestions?
Just try:
odsfinfo (<some_ods_file.ods>)
AFAICS it should just work now.
Please report any error messages you get.
Philip
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Octave-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/octave-dev