sheetjs
sheetjs copied to clipboard
Exponential format with no decimal/digits shouldn't display any
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.
A similar issue occurs in Engineering notation (for both float and int inputs), where 10 with format 000E-0 should give 010E0 not 1.000E1.