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

GetCellType for date format cell value returns as Unset #1932

Closed
Bowrna opened this issue Jun 27, 2024 · 2 comments
Closed

GetCellType for date format cell value returns as Unset #1932

Bowrna opened this issue Jun 27, 2024 · 2 comments
Labels
duplicate This issue or pull request already exists

Comments

@Bowrna
Copy link

Bowrna commented Jun 27, 2024

I have a excel sheet with cell value set as 2:31:30 AM in cell B13.

When I tried to invoke f.GetCellType('sheet 1', 'B13') returns 0. ( which implies the CellTypeUnset).
I tried to log the response and got this

Cell B3: Bowrna
Cell B3 Type: String
Cell C12: TRUE
Cell C12 Type: Bool
Cell B13: 2:31:30 am
Cell B13 Type: Unset

Expecting result for GetCellType: CellTypeDate

Go version
go version go1.22.4 darwin/arm64

Excelize version
github.com/xuri/excelize/v2 v2.8.1

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Apple M1 14.5, downloaded xlsx format from google sheets

@xuri
Copy link
Member

xuri commented Jun 29, 2024

Thanks for your issue. This duplicated with issues #1041 and #1375.

@xuri xuri added the duplicate This issue or pull request already exists label Jun 29, 2024
@xuri
Copy link
Member

xuri commented Jul 2, 2024

I've closed this. If you have any questions, please let me know, and reopen this anytime.

@xuri xuri closed this as completed Jul 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate This issue or pull request already exists
Projects
None yet
Development

No branches or pull requests

2 participants