sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

Exponential format with no decimal/digits shouldn't display any

Open snoopyjc opened this issue 5 years ago • 1 comments

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.

snoopyjc avatar Oct 13 '20 01:10 snoopyjc

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.

snoopyjc avatar Oct 13 '20 04:10 snoopyjc