Benjamin Lindner wrote: > Philip Nienhuis wrote: >> Subject says /almost/ all. >> >> I've added some scripts to the IO package for writing ODS spreadsheet >> files using the java package and ODF toolkit. (Preliminary support using >> jOpenDocument (also java-based) is also included but yet only of limited >> use.) >> Reading ODS was already possible. >> >> As it stands it works fairly reliably but the underlying java stuff may >> be a bit fragile on Windows (see other posting). On Linux I didn't hit >> any problems yet. >> >> An issue to be aware of is that ODS has dedicated value types for dates >> and times, while octave has not. This is quite unlike Excel spreadsheets >> where dates are essentially numerical data formatted as dates. >> Reading data/time from ODS spreadsheets is OK (they are converted to >> octave datenums) but for the other way round there is no reliable >> solution. >> Actually I did implement writing dates to ODS (that's just 10 lines of >> code) but as there's no way yet to distinguish numerical data and >> date/time data in an octave cell array that code is currently a bit >> pointless. >> >> Anyway, as far as spreadsheet processing goes I suppose octave is >> presently a bit more advanced than the competition ;-) > > Would you agree if I included it in the upcoming 3.2.4 octave/mingw32 > installer?
Of course I'd agree - I contributed these scripts to share them in the first place. That said, I might commit more bug fixes the next weeks & months if I stumble on "issues". So make a snapshot whenever it suits you. (Especially making ODS write support is a complicated issue so I do expect bugs....) As an aside, has anybody really tried the xls/ods scripts? I'd really appreciate wider use & testing.... & suggestions for improvement. > I will also include the recent SVN versions of the windows and java > packages as suggested previously on the list somewhere. I think that would be a good move anyway; & updated versions of these packages are simply indispensable for the current spreadsheet I/O support. As to the needed java classes (.jars): All of them seem to have "octave-compatible" licenses (Apache, GNU) but altogether they may constitute an undue number of megabytes for a binary octave download (see below). And as they are compressed archives they don't gzip very well. My suggestion would be that users download the jars themselves, perhaps aided by clickable urls in the installer or so. I'll add url hyperlinks in the (html) readme files in the doc subdir. Oh and I haven't had time to learn texinfo yet. I've made up html readme texts using OOo Writer; are there any easily usable html->texinfo converters around? Thanks, Philip Disk space needed for Java classes ---------------------------------- JExcelAPI .708 MB jOpenDocument1.2b2 2.5 MB odfdom (ODF toolkit) 4 MB xercesImpl.jar 1.2 MB POI (5 jars total:) 8.5 MB Total: 17 MB ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ Octave-dev mailing list Octave-dev@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/octave-dev
