sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

Exponential format with an embedded string gives incorrect results

Open snoopyjc opened this issue 5 years ago • 0 comments

Another odd one from valid.tsv.

console.log(SSF.format('0"abde".0"??"000E+00', 12.3456789))
12abde12.3??1.235E+01

Excel gives the correct answer:

1abde.2??346E+01

snoopyjc avatar Sep 29 '20 22:09 snoopyjc