[Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread

[Philip Nienhuis]

Update of bug #53401 (project octave):

                  Status:               Confirmed => Fixed                  
             Assigned to:                    None => philipnienhuis         

    _______________________________________________________

Follow-up Comment #7:

Indeed, when reading .ods date cells 693960 was added to an already correct
datenum, fixed here:
http://hg.code.sf.net/p/octave/io/rev/37fd8bda5423

However, reading .xlsx is correct. LibreOffice correctly converts its epoch
1-1-0000 to Excels' 1-1-1900, so Jan 1, 1900 gets to be 2, taking into account
the LO "bug" mentioned in the discussion below. Any date after Feb 28, 1900 is
returned as a correct Excel date value.
As this is an upstream bug I won't fix it in the io package.

I think an io-2.4.11 bug fix release incl. this fix will be out before
Octave-4.4.0 will be released.

Closing report.

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?53401>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/