99
edits
IO package: Difference between revisions
Jump to navigation
Jump to search
→Reading cells containing errors
| Line 112: | Line 112: | ||
==== Reading cells containing errors ==== | ==== 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 | 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 | Smaller gotcha's : | ||
* while reading, empty cells are sometimes not skipped but interpreted with numerical value 0 (zero). | * while reading, empty cells are sometimes not skipped but interpreted with numerical value 0 (zero). | ||
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. | * 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. | ||