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

Float string error #1360

Closed
tomgitcode opened this issue Sep 22, 2022 · 4 comments
Closed

Float string error #1360

tomgitcode opened this issue Sep 22, 2022 · 4 comments
Labels
confirmed This issue can be reproduced

Comments

@tomgitcode
Copy link

excel is config is 0.0724
but read out use excelize is "0.07239999999999999"
I use "require github.com/xuri/excelize/v2 v2.6.1"
how can i do?
@xuri xuri added the needs more info This issue can't reproduce, need more info label Sep 22, 2022
@xuri
Copy link
Member

xuri commented Sep 22, 2022

Thanks for your feedback. I have tested and it works well, could you provide your input file attachment without confidential info?

@tomgitcode
Copy link
Author

正常的填写浮点数是没有问题的也是能读出来是字符串，
我的这个0.0724是表格公式计算结果值。比如（C4-C5）*xxx==0.0724.

@tomgitcode
Copy link
Author

test.xlsx

@xuri xuri added confirmed This issue can be reproduced in progress Working in progress and removed needs more info This issue can't reproduce, need more info labels Sep 23, 2022
@xuri xuri closed this as completed in efcf599 Sep 27, 2022
@xuri xuri removed the in progress Working in progress label Sep 28, 2022
@xuri
Copy link
Member

xuri commented Sep 28, 2022

Thanks for your issue, I have fixed it. Please upgrade to the master branch code, and this patch will be released in the next version.

xuri added a commit to carbin-gun/excelize that referenced this issue Oct 9, 2022
@xuri
This closes qax-os#1360, closes qax-os#1361
9cd7be2 
- Fix default number format parse issue with a long string of digits
- Fix creating a sheet with an empty name cause a corrupted file
- The `GetCellStyle` function no longer return master cell style of the merge cell range
- Using the specialized name in variables and functions
xuri added a commit to JDavidVR/excelize that referenced this issue Jul 11, 2023
@xuri
This closes qax-os#1360, closes qax-os#1361
1c90649 
- Fix default number format parse issue with a long string of digits
- Fix creating a sheet with an empty name cause a corrupted file
- The `GetCellStyle` function no longer return master cell style of the merge cell range
- Using the specialized name in variables and functions
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
@xuri
This closes qax-os#1360, closes qax-os#1361
9dc5642 
- Fix default number format parse issue with a long string of digits
- Fix creating a sheet with an empty name cause a corrupted file
- The `GetCellStyle` function no longer return master cell style of the merge cell range
- Using the specialized name in variables and functions
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
confirmed This issue can be reproduced
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xuri @tomgitcode