# in a fraction format needs to format 0 as 0 #2582

New Issue

2020-09-29T22:20:46Z

snoopyjc commented

2020-09-29 22:20:46 +00:00

(Migrated from github.com)

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.

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.

Sign in to join this conversation.