[Octave-bug-tracker] [bug #57812] [octave forge] (io) xlsread imports accounting negative numbers as NaN

[Philip Nienhuis]

Follow-up Comment #5, bug #57812 (project octave):

Rather than applying a regexp to the ctvalue, it's easier to just get the
value of the "office:value" tag.
For io-2.6.0 I'll make that change but it may be that for percentages and
currencies a similar trick must be applied.

Until io-2.6.0 is out you can use the jOpendocument Java library as a
workaround; actually it's even much faster. Get it from jOpendocument.org, add
the library to the javaclasspath:

javaaddpath ('/full/path/to/jOpenDocument-1.4rc2.jar')

(it seems they never made it beyond a 1.4-rc2 release but it works fine)

and specify the "JOD" interface when using xlsread:

[numarr, txtarr, rawarr, limits] = xlsread ('Example.ods', 1, '', 'jod')


    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?57812>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/