sheetjs
sheetjs copied to clipboard
Formats with multiple leading 000s need to preserve these in the output
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)
This is matching 'dec1'.
We're also running into this bug. It's a pretty basic format though, it's the first one we tried.