[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Octave-bug-tracker] [bug #56373] xlswrite with windows pkg loaded produ
From: |
Nicholas Jankowski |
Subject: |
[Octave-bug-tracker] [bug #56373] xlswrite with windows pkg loaded produces erroneous NA output, v5.1.0 only |
Date: |
Wed, 22 May 2019 14:29:11 -0400 (EDT) |
User-agent: |
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 Edge/16.16299 |
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/
- [Octave-bug-tracker] [bug #56373] xlswrite with windows pkg loaded produces erroneous NA output, v5.1.0 only,
Nicholas Jankowski <=