changeset 10398:f5ef11958701 octave-forge

Updated / spell checks
author prnienhuis
date Thu, 07 Jun 2012 16:35:46 +0000
parents 03cd443b9c32
children 7ea56cf96654
files main/io/doc/READ-ODS.html main/io/doc/READ-XLS.html
diffstat 2 files changed, 21 insertions(+), 13 deletions(-) [+]
line wrap: on
line diff
--- a/main/io/doc/READ-ODS.html	Thu Jun 07 15:50:19 2012 +0000
+++ b/main/io/doc/READ-ODS.html	Thu Jun 07 16:35:46 2012 +0000
@@ -18,7 +18,7 @@
 	Copyright © 2009 - 2012 Philip Nienhuis &lt;prnienhuis at users.sf.net&gt;</font></font>
 </p>
 	<p align="center"><font face="Arial, sans-serif"><font size="2">
-	This version April 09, 2012</font></font>
+	This version June 07, 2012</font></font>
 </p>
 <p><font face="Arial, sans-serif"><font size="2">
 	<i>(ODS = Open Document Format spreadsheet data format, used by e.g., OpenOffice.org.)</i></font></font>
@@ -62,7 +62,11 @@
 	<font face="Arial, sans-serif"><font size="2"><b>calccelladdress.m</b></font></font></dt><dt style="font-style: italic;">
 	<font face="Arial, sans-serif"><font size="2"><b>parse_sp_range.m</b></font></font></dt><dt>
 	<font face="Arial, sans-serif"><font size="2">Support files called by
-	the scripts and not meant for direct invocation by users.</font></font></dt><dd></dd>
+	the scripts and not meant for direct invocation by users.</font></font></dt><dt>
+	<p><font face="Arial, sans-serif"><font size="2"><i><b>io_ods_testscript.m</b></i>
+	<br>Script for testing basic operation of ODS spreadsheet functions.</font></font></p><br></dt>  
+  
+
 </dl>
 <p align="center"><font face="Arial, sans-serif"><font size="4"><u><b>REQUIRED
 SUPPORT SOFTWARE</b></u></font></font></p><dl>
@@ -172,10 +176,10 @@
 	interface you can:</font></font></dt></dl>
 <ul>
 	<li>
-	<font face="Arial, sans-serif"><font size="2">(When reading, <b>od</b><b>s2oct</b>)
+	<font face="Arial, sans-serif"><font size="2">(When reading, <b>ods2oct</b>)
 	either read spreadsheet formula results, or the literal formula text
 	strings;</font></font></li><li>
-	<font face="Arial, sans-serif"><font size="2">(When writing, <b>oct2</b><b>od</b><b>s</b>)
+	<font face="Arial, sans-serif"><font size="2">(When writing, <b>oct2ods</b>)
 	either enter formulas in the worksheet as formulas, or enter them as
 	literal text strings.</font></font></li></ul>
 	<font face="Arial, sans-serif"><font size="2">In short, you can
@@ -550,7 +554,7 @@
 	<font face="Arial, sans-serif"><font size="2">oct2ods.m (revision
 	7159)</font></font></li></ul>
 	<p><font face="Arial, sans-serif"><font size="2">Enjoy!</font></font></p><p align="center"><font face="Arial, sans-serif"><font size="2">Philip
-	Nienhuis, April 09, 2012</font></font></p><dl><dd><p align="center">
+	Nienhuis, June 07, 2012</font></font></p><dl><dd><p align="center">
 	<br>
 </p></dd></dl>
 </body></html>
\ No newline at end of file
--- a/main/io/doc/READ-XLS.html	Thu Jun 07 15:50:19 2012 +0000
+++ b/main/io/doc/READ-XLS.html	Thu Jun 07 16:35:46 2012 +0000
@@ -13,7 +13,7 @@
 <BR>
 Copyright (C) 2009 - 2012 Philip Nienhuis &lt;prnienhuis at users.sf.net&gt;<BR>
 <BR>
-This version Februari 26, 2012</P>
+This version June 7, 2012</P>
 </FONT></FONT><B><U><FONT FACE="Arial, sans-serif" SIZE=4><FONT FACE="Arial, sans-serif" SIZE=4><P ALIGN="CENTER">EXCEL .XLS SUPPORT FILES</P>
 </B></U></FONT></FONT><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2><DL>
 <DT><BR>
@@ -48,7 +48,11 @@
 </DL>
 <B>spsh_chkrange.m</B>,</FONT></FONT> <B><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2>spsh_prstype.m</B>,</FONT></FONT> <B><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2>getusedrange.m</B>,</FONT></FONT> <B><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2>calccelladdress.m</B>,</FONT></FONT> <B><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2>parse_sp_range.m
 </B>
-<DT>Support files called by the scripts and not meant for direct invocation by users.</DT>
+<DT>Support files called by the scripts and not meant for direct invocation by users.<BR></DT>
+<BR>
+<DT><B>io_xls_testscript.m</B></DT>
+<DT>Script for testing basic features of the spreadsheet scripts.</DT>
+</DL>
 <P ALIGN="CENTER"><BR>
 </FONT></FONT><B><U><FONT FACE="Arial, sans-serif" SIZE=4><FONT FACE="Arial, sans-serif" SIZE=4>REQUIRED SUPPORT SOFTWARE</P>
 </B></U></FONT></FONT><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2><DL>
@@ -165,12 +169,12 @@
 </FONT></FONT><B><U><FONT FACE="Arial, sans-serif" SIZE=4><FONT FACE="Arial, sans-serif" SIZE=4><P ALIGN="CENTER">SPREADSHEET FORMULA SUPPORT</P>
 </B></U></FONT></FONT><FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2><DL>
 <DT><BR>
-When using the POI, JXL and UNO interfaces you can:</DT>
+When using the COM, POI, JXL, and UNO interfaces you can:</DT>
 </DL>
 
 <UL>
-<LI>(When reading, xls2oct) either read spreadsheet formula results (like in COM interface), or the literal formula text strings;</LI>
-<LI>(When writing, oct2xls) either enter formulas in the worksheet as formulas, or enter them as literal text strings. The former is also like in COM.</LI></UL>
+<LI>(When reading, xls2oct) either read evaluated spreadsheet formula results, or the literal formula text strings;</LI>
+<LI>(When writing, oct2xls) either enter text strings in the form of spreadsheet formulas in the worksheet as formulas, or enter them as literal text strings.</LI></UL>
 
 <P>In short, you can enter spreadsheet formulas and in a later stage read them back, change them and re-enter them in the worksheet.&nbsp;</P>
 <DL>
@@ -221,9 +225,9 @@
 <DT>JexcelAPI, unlike ApachePOI, doesn't evaluate functions while reading but instead relies on cached results (i.e. results computed by Excel itself). Depending on Excel settings (&quot;Automatic calculation&quot; ON or OFF) this may or may not yield incorrect (or expected) results. <BR>
 <BR>
 <b>Apache POI</b> (Java-based and platform-independent too) is based on the OpenOffice.org I/O Excel r/w routines. It is a more versatile than JExcelAPI, while it doesn't support BIFF5 it does support BIFF8 (Excel 97 – 2003) and OOXML (Excel 2007).</DT>
-<DT>It is slower than native JXL let alone Excel &amp; COM but it features active formula evaluation, although at the moment (v. 3.7) not all Excel functions have been implemented. I've made the relevant subfunction (xls2jpoi2oct) fall back to cached formula results (and yield a suitable warning) for non-implemented Excel functions while reading Excel files. <BR>
+<DT>It is slower than native JXL let alone Excel &amp; COM but it features active formula evaluation, although at the moment (v. 3.8) still not all Excel functions have been implemented. I've made the relevant subfunction (xls2jpoi2oct) fall back to cached formula results (and yield a suitable warning) for non-implemented Excel functions while reading Excel files. <BR>
 <BR>
-<b>OpenXLS</b> (an open source version of Extentech's commercial Java-xls product) is still experimental. It seems to work faster than JExcelAPI, but it has other issues - i.e., it locks the .xls file and the unlocking mechanism is a bit wonky. Sometimes xls files keep being locked until Octave is shut down. Currently OXS write support is disabled (but the code is there). OpenmXLS doesn't support reading back formulas astext strings.<BR>
+<b>OpenXLS</b> (an open source version of Extentech's commercial Java-xls product) is still experimental. It seems to work faster than JExcelAPI, but it has other issues - i.e., it locks the .xls file and the unlocking mechanism is a bit wonky. Sometimes xls files keep being locked until Octave is shut down. Currently OXS write support is disabled (but the code is there). OpenXLS doesn't support reading back formulas as text strings.<BR>
 <BR>
 <b>UNO</b> (invoking OpenOffice.org or clones behind the scenes, a la ActiveX) is experimental. It works FAST (i.e., once OOo itself is loaded which can take some time) and can process much larger spreadsheets than the other Java-based interfaces because the data are not entered in the JVM but in OOo's memory.<BR>
 A big stumbling block is that odsclose() on a UNO xls struct will kill ALL OpenOffice.org invocations, also those that were not related to Octave! This is due to UNO-Java limitations.<br>
@@ -323,6 +327,6 @@
 
 <P>Enjoy!</FONT></FONT> </P>
 <FONT FACE="Arial, sans-serif" SIZE=2><FONT FACE="Arial, sans-serif" SIZE=2><DL>
-<DD ALIGN="CENTER">Philip Nienhuis, Februari 26, 2012</DD>
+<DD ALIGN="CENTER">Philip Nienhuis, June 7, 2012</DD>
 </DL></FONT></FONT></BODY>
 </HTML>