sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

# in a fraction format needs to format 0 as 0

Open snoopyjc opened this issue 5 years ago • 0 comments

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.

snoopyjc avatar Sep 29 '20 22:09 snoopyjc