rubyXL icon indicating copy to clipboard operation
rubyXL copied to clipboard

Issue with parsing excel with 1900 and 1904 date system

Open swatijadhav opened this issue 12 years ago • 2 comments

While parsing xlsx file, the dates are returned as Fixnum format.

The excel files for which the property "Use 1904 date system" is set to true from file options. To get the original-date i have added,

Date.new(1904) + fixnum_int

But same code not works if the above property is not set. it gives the date 4 years greater than actual date.

Can you suggest me how to work around this issue or would i be able to distinguish the file 1900/1904 format, please guide. Thanks

swatijadhav avatar May 03 '13 15:05 swatijadhav

A new version of the gem has been released. Can you try and see if your issue has been resolved?

weshatheleopard avatar Feb 07 '14 01:02 weshatheleopard

Weather the test gets merged or not in the code I believe the issue can be closed since the tests are passing.

mauromorales avatar May 20 '14 20:05 mauromorales