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

When the field value type is a floating point type, the parsed data is wrong #852

Closed
hidahua opened this issue May 31, 2021 · 2 comments
Closed
Labels
confirmed This issue can be reproduced duplicate This issue or pull request already exists

Comments

@hidahua
Copy link

hidahua commented May 31, 2021

change excel filed to any format is the same error!

Steps to reproduce the issue:
1.excel filed value is: 2422.3 , use type General(or other type)
2.the value after reading is:2422.3000000000002

Describe the results you received:
2422.3000000000002
Describe the results you expected:
2422.3

Output of go version:
go1.15.5

Excelize version or commit ID:
master

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Linux and MacOs have the same error

@xuri
Copy link
Member

xuri commented May 31, 2021

This issue duplicates with #848. could you provide any attachment or code to reproduce this issue?

@xuri xuri added duplicate This issue or pull request already exists needs more info This issue can't reproduce, need more info confirmed This issue can be reproduced and removed needs more info This issue can't reproduce, need more info labels May 31, 2021
@xuri xuri added the in progress Working in progress label Jul 11, 2021
@xuri xuri closed this as completed in f62c45f Jul 11, 2021
@xuri xuri removed the in progress Working in progress 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.

jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
confirmed This issue can be reproduced duplicate This issue or pull request already exists
Projects
None yet
Development

No branches or pull requests

2 participants