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

Date rounding error #1030

Closed
asicerik opened this issue Sep 30, 2021 · 1 comment
Closed

Date rounding error #1030

asicerik opened this issue Sep 30, 2021 · 1 comment
Labels
confirmed This issue can be reproduced

Comments

@asicerik
Copy link

Description
Apparent rounding error reading dates in Golang code.

Steps to reproduce the issue:

  1. Load the value "9/11/2021 8:00:00 AM" into cell A1 (Excel date/time value 44450.3333333333)
  2. Load the spreadsheet, then read the value in cell A1 using GetCellValue()

Describe the results you received:
"9/11/2021 07:59"

Describe the results you expected:
"9/11/2021 08:00"

Output of go version:

go version go1.16.8 windows/amd64

Excelize version or commit ID:

v2.3.2

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

@xuri xuri added the confirmed This issue can be reproduced label Oct 8, 2021
@xuri xuri closed this as completed in 58fd279 Oct 11, 2021
@xuri
Copy link
Member

xuri commented Oct 11, 2021

Thanks for your issue, I applied the patch from your forked fix code.

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