Closed alexbrainman-anz closed 6 months ago
Thanks for your issue. This issue has been fixed, please upgrade to the master branch by go get -u github.com/xuri/excelize/v2@master
, and this patch will be released in the next version.
This issue has been fixed, please upgrade to the master branch by
go get -u github.com/xuri/excelize/v2@master
, and this patch will be released in the next version.
Thank you very much for fixing the bug so quickly.
Excellent job.
Alex
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 4eb088cf7 .
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