search

protobi / js-xlsx

XLSX / XLSM / XLSB (Excel 2007+ Spreadsheet) / ODS parser and writer
http://oss.sheetjs.com/js-xlsx
Other
833 stars 416 forks source link

How to force formula recalculation? #48

Closed kilpa closed 7 years ago

kilpa commented 7 years ago

Right now when you add formula =TODAY() into the xlsx file it will be ran and get cached as the value of the field. When reading the file with js-xlsx the formula is not ran and the value for the cell will be as it was when the file was last opened by a proper application (Excel, Calc etc.).

pietersv commented 7 years ago

@kilpa Thank you for reporting. This seems like a major capability. I recommend adding this as an issue to the root project https://github.com/SheetJS/js-xlsx also.

In the meantime, I believe it is possible to calculate the expected result independently and cache the result as a cell value.