sheetjs
sheetjs copied to clipboard
Escaped slash is treated as fraction separator
trafficstars
If a / is escaped like "/" or /, and it's in a place where it could be a fraction separator, then it is incorrectly treated as a fraction separator and not a literal slash.
console.log(SSF.format('???\/???', 123.45))
formats in Excel as ' /123' and here as '2469/20'.
This is from the ECMA Office XML Part 1 specification:
/ If this symbol is preceded and followed by a number symbol (0, #, and ?), it is interpreted as
the fraction format symbol and will display the number in the format of a fraction. Otherwise,
it is interpreted as the forward slash character and is displayed as such.