Eric P Sheets
Eric P Sheets
@jngbng thanks for going over this! Was not aware of the minute differences in KST. The date handling is a bit of a mess and we likely have to revisit...
@Fil "off by 4 years" sounds like a problem with the date system (1900 vs 1904) which is not related to the issue at hand. Please raise a new issue...
XLSX, XLSB, ODS and NUMBERS files are ultimately ZIP containers. You are seeing a ZIP file error. The version of APPNOTE.TXT that is aligned with XLSX is 6.2.0: https://pkware.cachefly.net/webdocs/APPNOTE/APPNOTE_6.2.0.txt Those...
If you can share a file (some writer is generating bad files) we can revisit this idea.
If the demo doesn't make sense, we probably are missing something. Here's a longer explanation. If this makes sense, please let us know how to improve the README: To run...
There is a plan to redo the demo and make it more interactive (like https://docs.sheetjs.com/docs/#export-an-html-table-to-excel-xlsx on the docs page). For now, replace the python line with ``` npx -y http-server...
The React demos have been revisited: https://docs.sheetjs.com/docs/demos/react is a general discussion of different internal states you can use in React apps. Each approach has a dedicated example which can be...
Interesting -- the absolute time tokens will be displayed as negative numbers while the normal datetime tokens elicit a `#VALUE!` error:
Sure, how would you handle cells that have a raw value (like a number or raw string)?
For cells that have formula expressions and values, you clearly would return the formula. The question is about cells that just have a value (no associated formula expression). Currently the...