sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

Formats with multiple leading 000s need to preserve these in the output

Open snoopyjc opened this issue 5 years ago • 2 comments

Formats with multiple leading 000s need to preserve these in the output:

console.log(SSF.format('000.0', 1))
1.0  (Excel gives 001.0)
console.log(SSF.format('000.#', 1))
1.  (Excel gives 001.)
console.log(SSF.format('000.0', 1.2))
1.2  (Excel gives 001.2)
console.log(SSF.format('000.#', 1.2))
1.2  (Excel gives 001.2)

snoopyjc avatar Sep 29 '20 03:09 snoopyjc

This is matching 'dec1'.

snoopyjc avatar Sep 29 '20 04:09 snoopyjc

We're also running into this bug. It's a pretty basic format though, it's the first one we tried.

clement911 avatar Oct 15 '20 16:10 clement911