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.

Sign up for GitHub

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

Jump to bottom

loss of precision when reading execl rows inclouding decimals? #848

Closed
WickyLeo opened this issue May 25, 2021 · 5 comments
Closed

loss of precision when reading execl rows inclouding decimals? #848

WickyLeo opened this issue May 25, 2021 · 5 comments

Comments

@WickyLeo
Copy link

Description

9.6732
2.2

when read excel file including decimals,
cell result is 9.6731999999999996, 2.2000000000000002
how to fix it?
@WickyLeo WickyLeo changed the title loss of precision when reading execl rows inclouding decimals loss of precision when reading execl rows inclouding decimals? May 25, 2021
@WickyLeo
Copy link
Author

@xuri

@xuri
Copy link
Member

xuri commented May 28, 2021

Thanks for your feedback, I have tested and it works well, could you create the issue by an issue template and provide more details?

@xuri xuri added the needs more info This issue can't reproduce, need more info label May 28, 2021
@xuri xuri mentioned this issue May 31, 2021
Closed
@hidahua
Copy link

hidahua commented May 31, 2021

202105-test.xlsx
tks！
Note: It is normal when using wps to open and save the file, but there is a problem with excel

@SinowZ
Copy link

SinowZ commented Jun 24, 2021

@xuri

@xuri xuri closed this as completed in f62c45f Jul 11, 2021
@xuri xuri removed the needs more info This issue can't reproduce, need more info label Jul 11, 2021
@xuri
Copy link
Member

xuri commented Jul 11, 2021

I have fixed this issue, please try to upgrade the master branch code, and this patch will be released in the next version.

@xuri xuri mentioned this issue Jul 21, 2021
Closed
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
@xuri
This closes qax-os#848 and closes qax-os#852, fix reading decimals pr…
3809146 
…ecision
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@xuri @hidahua @SinowZ @WickyLeo