sheetjs
sheetjs copied to clipboard
SheetJS
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
HTR: 1)use this as format string: [red]-##,# 2) `jj=ostr.length-1;` will break with length of undefined
According to the format code structure(`positive;negative;zero;text`), I expected '-' for zero, but I got 0. I think the problem here is using `General` as formatted code for `positive` section. When...
I have found a custom format that is not applying correctly. ```#,##0.0000 %``` If I remove the space it works correctly, but the files I am processing are from a...
You have no international support and dates are formatted according underlying Locale. Can you inject a `ssf.setLocal(localString)` to ensure dates are correctly formatted?
SSF seems to only support English-based number formatting. Some foreign-language requires numbers to be formatted inverting thousands and decimal separators, such as French: `1234.56` would be displayed as : `1...
I have an xlsx file including some big numbers below.  After converting this file using XLSX.sheet_to_json(), the part of result data is ``` "B50": { "t": "n", "v": 23000000,...
When adding `#` symbols to the right of the decimal (like in a currency) I'm getting errors like `Error: unsupported format |#,###.00##|` Here's an example: ```js console.log(SSF.format('$#,###.00', 1.1111)); // "$1.11"...
when time is of a value that should round up the minute, if the second has a u (rounding value I assume) greater than or equal to .5, then the...
