[Octave-bug-tracker] [bug #51512] of-io: Missing or wrong types when using xlsread with OCT interface

[Philip Nienhuis]

Follow-up Comment #3, bug #51512 (project octave):

Markus, I'm busy with it; may take some time.

I'm not surprised LibreOffice (and for that matter, OpenOffice.org) and Excel
write the OOXML differently, that was a quirk I had to code around early on.
That's one of the tricky things when reading XML with regexps rather than with
an XML parser - XML gurus tend to frown upon that. This is a major weak point
in the OCT spreadsheet interface.

I see a new subfunc "is_bool_value". I'd like to find out if adapting regexps
is faster.
The OCT interface used to be blazingly fast for OOXML, much faster than Excel
and Matlab, but adding more and more type/subtypes (than just double) and
Excel-quirk-workarounds made it less efficient.
So I think the way this should be fixed (regexp, or postprocessing regexp
output in a separate subfunc, or some other way) should depend on timings with
large test spreadsheets, ideally with mixed types.


    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?51512>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/