[Octave-bug-tracker] [bug #56375] xlswrite and odswrite produce different outputs for NA and NaN

[Nicholas Jankowski]

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

                 Summary: xlswrite and odswrite produce different outputs for
NA and NaN
                 Project: GNU Octave
            Submitted by: nrjank
            Submitted on: Wed 22 May 2019 07:45:59 PM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  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:

as discussed in bug #56373,  odswrite produces .ods files with 0 in place of
NA or NaN array values.  Octave's xlswrite output is a blank cell for NA and
NAN. The NaN output is Matlab compatible behavior. Matlab does not appear to
support NA or ODS output.

Note that bug #56373 describes an issue where xlswrite is producing 65536
instead of blanks for certain versions/packages. This appears to be separate
from this odswrite issue.



>> pkg load io
>> chk_spreadsheet_support ()
ans = 0
>> 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

>> odswrite('testNA.ods',a)
Detected ODS interfaces: OCT*; (* = default interface)
ans =  1

output file has all zeros. 


close/restart, then:

>> pkg load io
>> pkg load windows
>> chk_spreadsheet_support ()
ans =  1
>> 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

>> odswrite('testNA.ods',a)
Detected ODS interfaces: OCT*; (* = default interface)
ans =  1



again, output file has all zeros.  same behavior with NaN.





    _______________________________________________________

Reply to this item at:

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

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