Wrong datetime conversion from xls

[paologf]

Hi,
i'm reading a .xlsx file that has some date cells (excel format is "date") but i had a wrong conversion.
If my A1 cell is 01-01-2000 (1st January 2000) the result of (get (spreadmap filename) "A1") is #inst "1995-12-30T23:00:00.000-00:00" , 1 hour, 1day and 4 year before the correct date.
I tried to read from an old .xls file or change date format (e.g. dd/mm/yyyy hh:mm) but the result is the same.

I can upload an example file if needed, but i think is very simply to reproduce.

PS: i'm using the last spreadmap, the 0.1.4

[cgrand]

Excel and it's two epochs...
Are you using Office for Mac?

On Tue, Aug 19, 2014 at 6:20 PM, paologf notifications@github.com wrote:

Hi,
i'm reading a .xlsx file that has some date cells (excel format is "date")
but i had a wrong conversion.
If my A1 cell is 01-01-2000 (1st January 2000) the result of (get
(spreadmap filename) "A1") is #inst "1995-12-30T23:00:00.000-00:00" , 1
hour, 1day and 4 year before the correct date.
I tried to read from an old .xls file or change date format (e.g.
dd/mm/yyyy hh:mm) but the result is the same.

I can upload an example file if needed, but i think is very simply to
reproduce.

PS: i'm using the last spreadmap, the 0.1.4

—
Reply to this email directly or view it on GitHub
#5.

On Clojure http://clj-me.cgrand.net/
Clojure Programming http://clojurebook.com
Training, Consulting & Contracting http://lambdanext.eu/

[paologf]

Yes, i'm using office for mac.
I created a new document with open office and i had only 1 hour gap (is it normal?).

[cgrand]

The open office issue also explains why you were off by 4 years, 1 day
and 1 hour.
I'm going to fix it asap.

On Wed, Aug 20, 2014 at 9:21 AM, paologf notifications@github.com wrote:

Yes, i'm using office for mac.
I created a new document with open office and i had only 1 hour gap (is it
normal?).

—
Reply to this email directly or view it on GitHub
#5 (comment).

On Clojure http://clj-me.cgrand.net/
Clojure Programming http://clojurebook.com
Training, Consulting & Contracting http://lambdanext.eu/

[paologf]

Ok, thanks.

[cgrand]

Could you provide me with an excel-created spreadsheet? (I don't have
Office for Mac)
Also: do you use spreadmap on a different computer than the one used to
create the spreadsheet (I'm still fuzzy about the root cause of the 1 hour
difference, a timezone problem but where...).

Thanks

On Wed, Aug 20, 2014 at 9:30 AM, paologf notifications@github.com wrote:

Ok, thanks.

—
Reply to this email directly or view it on GitHub
#5 (comment).

On Clojure http://clj-me.cgrand.net/
Clojure Programming http://clojurebook.com
Training, Consulting & Contracting http://lambdanext.eu/

[paologf]

The foo.xlsx file https://dl.dropboxusercontent.com/u/23365785/foo.xlsx done with office for mac, cell "A1" with 01/01/2000 00:00.
From mac i had the "1 hour" issue reading file done with open office or microsoft office (windows).
From linux i had the "1hour, 1day and 4 year" issue reading office for mac file.

Let me know if you need something more, thanks.

Paolo