[Octave-bug-tracker] [bug #56373] xlswrite with windows pkg loaded produces erroneous NA output, v5.1.0 only

[Nicholas Jankowski]

URL:
  <https://savannah.gnu.org/bugs/?56373>

                 Summary: xlswrite with windows pkg loaded produces erroneous
NA output, v5.1.0 only
                 Project: GNU Octave
            Submitted by: nrjank
            Submitted on: Wed 22 May 2019 06:29:09 PM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Regression
                  Status: None
             Assigned to: None
         Originator Name: Nicholas Jankowski
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 5.1.0
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

>From a help list conversation [1] it was determined that under certain
conditions the xlswrite function would produce different outputs for NA valued
array elements than in previous versions. 

Expected (and Matlab compatible) output is for NA elements to produce blank
cells in an XLSX file.  

With both io and windows packages loaded on a PC that has MS Office, tests
with 4.4.1 show compatible behavior. In 5.1.0, the cells are instead filled
with 65535:


>> pkg load io
>> pkg load windows
>> a = NA(5)
a =

    NA    NA    NA    NA    NA
    NA    NA    NA    NA    NA
    NA    NA    NA    NA    NA
    NA    NA    NA    NA    NA
    NA    NA    NA    NA    NA

>> xlswrite('testNA.xlsx',a)
Detected XLS interfaces: COM*; (* = default interface)
ans =  1

testNA.xlsx file shows:

65535   65535   65535   65535   65535
65535   65535   65535   65535   65535
65535   65535   65535   65535   65535
65535   65535   65535   65535   65535
65535   65535   65535   65535   65535



Closing Octave and repeating without loading the windows package, the cells
are blank as expected. The same happens for cells containing NaN.  

mailing list comments indicate testing with 5.1.1 and 6.0.0 builds cannot
recreate the problem. 

Also, possibly a separate issue, or just a nonissue, odswrite produces zeros
instead of blank cells for both NA and NAN whether or not the windows package
is loaded.
 






[1]
http://octave.1599824.n4.nabble.com/Nan-and-write-on-excel-65535-tp4692834p4692900.html




    _______________________________________________________

Reply to this item at:

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

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