[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Octave-bug-tracker] [bug #51512] of-io: Missing or wrong types when usi

From: Philip Nienhuis
Subject: [Octave-bug-tracker] [bug #51512] of-io: Missing or wrong types when using xlsread with OCT interface
Date: Fri, 21 Jul 2017 03:41:41 -0400 (EDT)
User-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0 SeaMonkey/2.46

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:


  Message sent via/by Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]