iso-8601 dates are strange floating points?

caxlsx / caxlsx_rails

A Rails plugin to provide templates for the axlsx gem

MIT License

735 stars 84 forks source link

iso-8601 dates are strange floating points? #144

Closed patrick99e99 closed 3 years ago

patrick99e99 commented 3 years ago

if I put a value like "2014-01-17T00:44:28.000Z" in a column, in excel/numbers it shows up as a number like: 44069.032777581

How can I make caxlsx keep it as the original iso string?

straydogstudio commented 3 years ago

@patrick99e99 You'll get better responses if you create this issue on the caxlsx gem, since it is really essential to that gem, not the rails adapter. Please recreate there.

patrick99e99 commented 3 years ago

ok thanks.