[Octave-bug-tracker] [bug #53401] io: dates from xlsread vs. odsread

[Muhali]

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

                 Summary: io: dates from xlsread vs. odsread
                 Project: GNU Octave
            Submitted by: muhali
            Submitted on: Wed 21 Mar 2018 06:45:12 AM PDT
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: None
                  Status: None
             Assigned to: None
         Originator Name: 
        Originator Email: 
             Open/Closed: Open
         Discussion Lock: Any
                 Release: dev
        Operating System: GNU/Linux

    _______________________________________________________

Details:

I have entered the date 1900-01-01 into Libreoffice Calc, and saved it to both
foo.ods and foo.xlsx. With octave I get the following:

octave:8> ODS = odsread("foo.ods")
ODS = 1387922
octave:9> XLS = xlsread("foo.xlsx")
XLS = 2

According to the documentation, ods has a base date of 0000-01-01 and xlsx one
of 1900-01-01. But

1. The value of ODS does not equal 693962 = datenum(1900,1,1).
2. The value of XLS does not equal 1.


Am I on a totally wrong track here?




    _______________________________________________________

Reply to this item at:

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

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