IO package: Difference between revisions

IO package (edit)

Revision as of 21:52, 30 November 2013

231 bytes removed , 30 November 2013

→‎Reading cells containing errors

Philipn

99

edits

@@ Line 112: / Line 112: @@
 ==== Reading cells containing errors ====
-Spreadsheet cells containing erroneous stuff are transferred to Octave as NaNs. But not all errors can be catched. Cells showing #Value# in OpenOffice.org Calc often contain invalid formulas but may have a 0 (null) value stored in the value fields. It is impossible to catch this as there is no run-time formula evaluator (yet) in ODF Toolkit nor jOpenDocument (like there is in Apache POI for Excel).
+Spreadsheet cells containing erroneous stuff are transferred to Octave as NaNs. But not all errors can be catched. Cells showing #Value# in OpenOffice.org Calc due to e.g., invalid formulas, may have a 0 (zero) value stored in the value fields. It is impossible to catch this as there is no run-time formula evaluator (yet) in ODF Toolkit nor jOpenDocument (like there is in Apache POI for Excel).
-Smaller gotcha's (only with jOpenDocument 1.2b2, fixed in 1.2b3+ and 1.2 final):
+Smaller gotcha's :
 * while reading, empty cells are sometimes not skipped but interpreted with numerical value 0 (zero).
-* a valid range MUST be specified, I haven't found a way to discover the actual occupied rows and columns (jOpenDocument can give the physical ones (= capacity) but that doesn't help).
-NOT fixed in version 1.2 final:
+NOT fixed in jOpenDocument version 1.2 & 1.3 final:
 * jOpenDocument doesn't set the so-called <office:value-type='string'> attribute in cells containing text; as a consequence ODF Toolkit will treat them as empty cells. OOo will read them OK.