-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
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
File.CalcCellValue returns wrong value for "=ROUND(1444.00000000000003,2)" #1851
Comments
realzuojianxiang
added a commit
to realzuojianxiang/excelize
that referenced
this issue
Mar 22, 2024
10 tasks
Thanks for your issue. This issue has been fixed, please upgrade to the master branch by |
Thank you very much for fixing the bug so quickly. Excellent job. Alex |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Description
I am using
=ROUND(1444.00000000000003,2)
formula in my Excel files.
I am calling
File.CalcCellValue
method on those formulas withOptions{RawCellValue: true}
option. I expect to see no digits after decimal point, but I see1444.0000000000002
returned.Steps to reproduce the issue:
I used this commit 4eb088c .
I made these changes to the code:
I run this command:
Describe the results you received:
I see this output:
Describe the results you expected:
Output of
go version
:Excelize version or commit ID:
Environment details (OS, Microsoft Excel™ version, physical, etc.):
I use MacOS. I do not have Excel installed.
This code used to work properly before a258e3d - I used git bisect to find that.
Thank you very much for your assistance.
Alex
The text was updated successfully, but these errors were encountered: