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

decimal records are not processed correctly #16

Closed
crepon-philipp opened this issue Jun 2, 2020 · 2 comments
Closed

decimal records are not processed correctly #16

crepon-philipp opened this issue Jun 2, 2020 · 2 comments

Comments

@crepon-philipp
Copy link

crepon-philipp commented Jun 2, 2020

I have a file containing multiple decimal values.
0.001 | 0.01 | 0.1

when parsing the data as described in README the first decimal is not returned correctly!

This is what I do:

x = Xsv::Workbook.open("sheet.xlsx")
sheet = x.sheets[0]
sheet.each_row do |row|
  p '---row', row
end

This is what I see in the console (the first value is just 1 instead of 0.001):
[1, 0.01, 0.1]

@martijn
Copy link
Owner

martijn commented Jun 2, 2020

Could you share your file? My email address is in my profile.

@martijn martijn closed this as completed in 17956c4 Jun 3, 2020
@martijn
Copy link
Owner

martijn commented Jun 3, 2020

Turns out the value was stored as a complex number in the XML (1E-3). Haven't seen that before and didn't notice it in the specification either. This is fixed in Xsv 0.3.16.

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

2 participants