Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with parsing excel with 1900 and 1904 date system #53

Open
swatijadhav opened this issue May 3, 2013 · 2 comments
Open

Issue with parsing excel with 1900 and 1904 date system #53

swatijadhav opened this issue May 3, 2013 · 2 comments

Comments

@swatijadhav
Copy link

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

@weshatheleopard
Copy link
Owner

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

mauromorales added a commit to mauromorales/rubyXL that referenced this issue May 20, 2014
@mauromorales
Copy link

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

aliismayilov pushed a commit to aliismayilov/rubyXL that referenced this issue Mar 9, 2021
aliismayilov pushed a commit to aliismayilov/rubyXL that referenced this issue Mar 9, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants