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

Rounding errors #727

Closed
jttodd opened this issue Nov 10, 2020 · 1 comment
Closed

Rounding errors #727

jttodd opened this issue Nov 10, 2020 · 1 comment
Labels
confirmed This issue can be reproduced

Comments

@jttodd
Copy link

jttodd commented Nov 10, 2020

Steps to reproduce the issue:

A1 = .1
A2 = .2
A3 = formula A1 + A2

Value of A3 in Excel is .3

Describe the results you received:

Value returned from GetCellValue for A3 is 0.30000000000000004

Describe the results you expected:

Expected value returned from GetCellValue for A3 of 0.3

Output of go version:

go version go1.15.3 windows/amd64

Excelize version or commit ID:

github.com/360EntSecGroup-Skylar/excelize v1.4.1

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Windows

@xuri xuri added confirmed This issue can be reproduced in progress Working in progress labels Nov 19, 2020
@xuri xuri closed this as completed in 599a8cb Nov 19, 2020
@xuri
Copy link
Member

xuri commented Nov 19, 2020

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

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
Projects
None yet
Development

No branches or pull requests

2 participants