sheetjs
sheetjs copied to clipboard
SheetJS
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
When converting json data to a text or csv it is converting characters like ’ to ’ I see that changing it to use UTF will supposedly fix it according...
Is it possible to identify the type of format using the format string ? For examples, i would like to have a function like: SSF.getFormat("m-d-yy h:mm;@") should return "Date" Similarly,...
If you have an Excel with time data with milliseconds (eg 10:25:59.50) the cell.v is rounded but it does not affect the minute, neither the hour. For example : 10:21:26.75...
Format string '#,##0.##########' throws error: unsupported format |#,##0.##########|
Is it possible to customize the decimal and thousands separator, or provide a custom locale? Many locales use different separators, such as comma for decimal separator and space for thousands...
Is there any way to access modified version of value as number ? For example, Input = 1.2345678 Format = "$ 0.00" Formatted string = "$ 1.23" Can we get...
`SSF.format('0.0000000', 0.0000001)` gives `1e-7.0000000` instead of `0.0000001`. `SSF.format('#.0', 1E30)` gives `1e+30.0` instead of `1000000000000000000000000000000.0`
An exponential format with no decimal/digits such as `#E-0` shouldn't display the decimal point and digit after it, e.g. `3.14159` displays incorrectly as `3.1E0` instead of `3E0`.
Negative number is wrongly formatted to positive number in a condition format Format: `[>=1000000]#,,\" M\";####.00` Value: `-12.3` Actual: `12.3` Expected: `-12.3` **Sample Program** console.log(`${value} => ${X.SSF.format([>=1000000]#,,\" M\";####.00, -12.3)}\t\t format: ${format}``)...
The sign needs to float before any '?' in the format. Eg: console.log(SSF.format('#????', -12.2)) -12 Excel gives: - 12