sheetjs
sheetjs copied to clipboard
# in a fraction format needs to format 0 as 0
To match how excel works, a # in a fraction format needs to be filled in with a given 0 to format. Details:
console.log('"' +SSF.format('# ?/10', 0)+'"')
" "
Excel gives "0 ", however Excel doesn't do this if the format is just '#'.
This is from valid.tsv.