[Top][All Lists]

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

Re: Nan and write on excel "65535"

From: PhilipNienhuis
Subject: Re: Nan and write on excel "65535"
Date: Tue, 21 May 2019 12:03:01 -0500 (CDT)

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.


Sent from:

reply via email to

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