sheetjs Negative time delta values should format correctly

Negative time delta values should format correctly

Open snoopyjc opened this issue 5 years ago • 1 comments

In Excel, a negative time difference formats with a negative sign. SSF returns a blank result:

console.log('"' + SSF.format('[HH]', -12) + '"')
""

Oct 01 '20 19:10 snoopyjc

Interesting -- the absolute time tokens will be displayed as negative numbers while the normal datetime tokens elicit a #VALUE! error:

Jul 07 '22 05:07 SheetJSDev