Re: Nan and write on excel "65535"

[PhilipNienhuis]

nrjank wrote
> On Mon, May 20, 2019 at 11:52 AM Nicholas Jankowski <

> jankowskin@

> > wrote:
>>
>> using Octave 5.1.0 on Windows 10 Pro, with MS Office 2013 and Java(TM)
>> SE Runtime Environment (build 1.8.0_212-b10)
>> (I don't have a pc without MS Office for testing.)
>>
>> my simple test case:
>>
> 
> realized I still have v4.4.1 sitting around.  running the same tests,
> the xlsx files are both blank for NA and NAN and the ods files are
> both filled with zeros.
> 
> so definitely a change between versions. I don't know what the desired
> behavior
> is. previous behavior (blank) matches Matlab for compatibility.  no
> compatibility issue with ODS output due to Matlab not apparently
> handling that format natively, but it seems odd that the two wouldn't
> match.

With a self-crossbuilt Octave-6.0.0, I get (as to be expected) completely
empty spreadsheets for below commands:

>> xlswrite ("NaN.xlsx", NaN (3, 3), "NaN", "B2:G8", "oct")
Checking requested interface(s):
OCT*; (* = default interface)
ans =  1
>> xlswrite ("NaN.xlsx", NA (3, 3), "NaN", "B2:G8", "oct")
>> NA(3, 3)  ##  Just to see if that works as well
ans =
    NA    NA    NA
    NA    NA    NA
    NA    NA    NA
## So it does work

>> xlswrite ("NA.xlsx", NA (3, 3), "Na", "B2:G8", "oct")
ans =  1
>>

Same if I use COM instead of OCT interface (the issue was with default COM
if windows pkg is loaded, right?)

I have no Octave-5.1.0 installed (and no time to install it), but AFAICS
Octave-6.0.0 is doing the right thing.

Philip




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