Joe Cool

Here is an updated implied.json. Note that I use dateNF="m/d/yy" so I didn't change those entries: [ [1234567890000, [ [0, "1.23457E+12"], [1, "1234567890000"], [2, "1234567890000.00"], [3, "1,234,567,890,000"], [4, "1,234,567,890,000.00"], [9,...

 

I get an error message on this one: console.log(SSF.format("[red]-##,#", 1)) error: Error: unsupported format |##,#| If I put the comma in the proper place, then it works as expected: console.log(SSF.format("[red]-#,###",...

Suggested fix: // if(isgeneral(sfmt,0)) return general_fmt(v, o); ov = v; if(v instanceof Date) v = datenum_local(v, o.date1904); var f = choose_fmt(sfmt, v); // if(isgeneral(f[1])) return general_fmt(v, o); if(isgeneral(f[1])) return general_fmt(ov,...

The '%' character needs to be treated as any other escaped character in the format in that it appears unchanged in the output in the same place it appears in...

The rounding algorithm needs to be rethought. Basically if you round the uS, then you need to carry that rounding all the way across, so it's better to just punt...

This looks like CSV output and you need to properly interpret it as in quotes, the commas are not separators. Try using the [csv](https://docs.python.org/3/library/csv.html) module instead of just using `str.split(',')`.

Too funny how this wound up as issue SheetJS/sheetjs#2554! You mention in the reference that the dateNF option fixes this issue. Should it be closed?

Yes, I'm having this problem too - just wasted a couple hours in the debugger trying to figure out why the 4th of July goes until the 6th!

Timeline also says that the 4th of July Holiday is also an event on July 5th. Errors in {included, overlapping, at} where you check start