[Top][All Lists]

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

[Octave-bug-tracker] [bug #57812] [octave forge] (io) xlsread imports ac

From: Philip Nienhuis
Subject: [Octave-bug-tracker] [bug #57812] [octave forge] (io) xlsread imports accounting negative numbers as NaN
Date: Sat, 15 Feb 2020 16:51:33 -0500 (EST)
User-agent: Mozilla/5.0 (Windows NT 6.1; rv:52.0) Gecko/20100101 Firefox/52.0

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:


  Message sent via Savannah

reply via email to

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