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

The positiveHandler method returns an incorrect value #1985

Closed
ying32 opened this issue Sep 1, 2024 · 3 comments · Fixed by #1986
Closed

The positiveHandler method returns an incorrect value #1985

ying32 opened this issue Sep 1, 2024 · 3 comments · Fixed by #1986
Labels
bug Something isn't working

Comments

@ying32
Copy link

ying32 commented Sep 1, 2024

Description
当单元格内容为手机号时且单元格式为常规类型,此时被粗暴的转为浮点类型,造成结果不正确。
例如13812349876结果将会变成1.381234988E+10
此bug由2024/3/19 8:58:52提交所生产的,相关提交id9e884c798be12fc1b2b985ed2db7f09f765f990a,如下图:

image

@xuri
Copy link
Member

xuri commented Sep 1, 2024

Thanks for your issue. Could you show us a complete, standalone example program or reproducible demo? If you open an existing workbook, please provide the file attachment without confidential info.

@xuri xuri added the needs more info This issue can't reproduce, need more info label Sep 1, 2024
@ying32
Copy link
Author

ying32 commented Sep 1, 2024

ok!
sample.xlsx

@xuri xuri added bug Something isn't working and removed needs more info This issue can't reproduce, need more info labels Sep 1, 2024
peng added a commit to peng/excelize that referenced this issue Sep 1, 2024
xuri pushed a commit that referenced this issue Sep 2, 2024
@xuri xuri closed this as completed in #1986 Sep 2, 2024
@xuri
Copy link
Member

xuri commented Sep 2, 2024

Thanks for your feedback. This issue has been fixed, please upgrade to the master branch code by go get -u github.com/xuri/excelize/v2@master.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants