[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread
From: |
Philip Nienhuis |
Subject: |
[Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread |
Date: |
Fri, 23 Mar 2018 16:45:50 -0400 (EDT) |
User-agent: |
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0 SeaMonkey/2.48 |
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/
- [Octave-bug-tracker] [bug #53401] io: dates from xlsread vs. odsread, Muhali, 2018/03/21
- [Octave-bug-tracker] [bug #53401] io: dates from xlsread vs. odsread, Philip Nienhuis, 2018/03/21
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Mike Miller, 2018/03/21
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Muhali, 2018/03/22
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Philip Nienhuis, 2018/03/22
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Muhali, 2018/03/22
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Philip Nienhuis, 2018/03/22
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Philip Nienhuis, 2018/03/23
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread,
Philip Nienhuis <=
- [Octave-bug-tracker] [bug #53401] [octave forge] (io) dates from xlsread vs. odsread, Philip Nienhuis, 2018/03/23