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
Describe the bug
My xlsx file has formulas to calculate dates. The xlsx package will return the calculated value when the sheet was last saved, whereas exceljs package will automatically re-evaluate the formulas
To Reproduce
Create an XLSX file and add a cell value with a formula such as ="The time right now is "&TEXT(NOW(), "hh:mm:ss")
Expected behavior
When the cell value is read, it should give me the latest time and not the time when the sheet was last updated manually
Screenshots and Log files
If applicable, add screenshots and/or logfiles to help explain your problem.
For Botium CLI, add the --verbose command line switch
Botium Flavour:
Botium CLI
Botium Version
Is there an exact version where this bug is happening ?
Additional context
btw the xlsx npm package is deprecated and SheetJS recommends to use the CDN version, however, I would recommend using the exceljs package instead
The text was updated successfully, but these errors were encountered:
Describe the bug
My xlsx file has formulas to calculate dates. The xlsx package will return the calculated value when the sheet was last saved, whereas exceljs package will automatically re-evaluate the formulas
To Reproduce
Create an XLSX file and add a cell value with a formula such as ="The time right now is "&TEXT(NOW(), "hh:mm:ss")
Expected behavior
When the cell value is read, it should give me the latest time and not the time when the sheet was last updated manually
Screenshots and Log files
If applicable, add screenshots and/or logfiles to help explain your problem.
Botium Flavour:
Botium Version
Additional context
btw the xlsx npm package is deprecated and SheetJS recommends to use the CDN version, however, I would recommend using the exceljs package instead
The text was updated successfully, but these errors were encountered: