sheetjs
sheetjs copied to clipboard
SheetJS
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
Invalid format message for ?.? (and for .?) for float input. It works fine for int input. console.log(SSF.format('?.?', 1.2)) Error: unsupported format |?.?| console.log(SSF.format('?.?', 1)) 1.
The test/valid.tsv file contains tests of valid Excel formats, however Excel (2010 at least), no longer accepts [ENG] as a prefix to a format, so I just recommend just taking...
Formats like ##0.0E+0 are a generalized form of Engineering notation, where the exponent is to be a multiple of the number of digits before the '.'. Using this specified format,...
If a / is escaped like "/" or \/, and it's in a place where it could be a fraction separator, then it is incorrectly treated as a fraction separator...
Another one from the valid.tsv suite: If a fraction format has text between the integer part and the fraction, then the result integer and denominator is wrong. Example: console.log(SSF.format('#"aabded"\\ ??/??',...
This is definitely from the "oddity" category! If you have a Number Format that does not have any numeric (or date) parts to it, and only 1 section (no ';'),...
The `fix_hirji(date, o)` function is being passed a Date object for `date`, but then the code is checking `if(date < 60)...`. This can't be right as you're comparing a Date...
The default format for dates in Excel 2010 and newer includes a 4-digit year. So SSF.format(14, new Date(2017, 1, 19)) (or using 'General' format) should be "2/19/2017", not "2/19/17".
";" is incorrectly treated as a format separator. It should output a literal ; instead. Try: ";" 0.### in the live demo. You get no output for the pi input...
