Re: Nan and write on excel "65535"

[PhilipNienhuis]

help-octave-3 wrote
> hi,
> but i don't understand how i solve it  
> 
> in octave 4.XX i don't see this problem..
> 
> I see problem in octave 5.1..
> 
> (octave 6.0 it's not out yet)

Luckily (or not) for you, I tried with Octave-5.1.0 and indeed, with the COM
interface (= invoking Excel behind the scenes) I get numerical "65536"
entries in place of NaN and NA "values".
With a "5.1.1" build (which after more fixes will become 5.2.0) I do NOT see
this bug.

I have no explanation for this, it's beyond me.
For me it is reassuring that the bug disappeared in later releases :-)

A workaround for you wold be to UNload the windows package. In that case
Excel won't be invoked and Octave will use native code and that doesn't have
the bug.

BTW, it never occurred to me to test for this NA/NaN behavior. I'll adapt
the spreadsheet test scripts in the io package to check for this.

Philip




--
Sent from: http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html