You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CalcCellValue treats dates as strings. As a consequence CalcCellValue is unable to process dates in formulas:
mathemical expressions give parsing error
comparison fails: "19-08-2021" > "20-07-2022", but should be the opposite
Steps to reproduce the issue:
Download date.zip and unzip it
Run the go file: go run ./date.go
Describe the results you received:
> go run ./date.go
date.xlsx
Sheet1!C2: error: strconv.ParseFloat: parsing "03/08/21": invalid syntax
Sheet1!C3: error: strconv.ParseFloat: parsing "19/08/21": invalid syntax
Describe the results you expected:
> go run ./date.go
date.xlsx
Sheet1!C2: sucess: "05-08-21"
Sheet1!C3: should be true: "true"
Output of go version:
go version go1.16.7 linux/amd64
Excelize version or commit ID:
> git log
commit a55f354eb3d0c6c1b9a543ff8ff98227aa6063a6 (HEAD -> lookup, origin/master, origin/HEAD, master)
Author: xuri <xuri.me@gmail.com>
Date: Tue Aug 17 00:01:44 2021 +0800
This closes #989, closes #990
New API: `SetRowStyle` support for set style for the rows
Update documentation for the `GetRows`, `SetCellStyle` and `SetColStyle`
Environment details (OS, Microsoft Excel™ version, physical, etc.):
- Support text comparison in the formula, also ref qax-os#65
- `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref qax-os#621
- Add missing properties for the cell formula
- Update the unit test for the `CalcCellValue`
date.zip
Description
CalcCellValue treats dates as strings. As a consequence CalcCellValue is unable to process dates in formulas:
Steps to reproduce the issue:
Describe the results you received:
Describe the results you expected:
Output of
go version
:Excelize version or commit ID:
Environment details (OS, Microsoft Excel™ version, physical, etc.):
The text was updated successfully, but these errors were encountered: