ssf icon indicating copy to clipboard operation
ssf copied to clipboard

:memo: Spreadsheet Number Formatter

Results 8 ssf issues
Sort by recently updated
recently updated
newest added

This pull request allows specials characters (; \\ * _) to be inside double quotes in format definition. For example, "***";"_*_". If a format string is defined as #,###;; (return...

Proposed fix for SheetJS/js-xlsx#1212 based on code by @cdmahoney

Suggested fix for https://github.com/SheetJS/js-xlsx/issues/1105

[When I provide](https://oss.sheetjs.com/ssf/) the value `0.00556` with the format `[h]:mm:ss` the result is `0:08:00` (which is correct), however when provided the value `0.00555` the result is `0:07:00`. I expect that...

[When I provide](https://oss.sheetjs.com/ssf/) the negative value `-1.00069444444444` with the format `[h]:mm:ss` the result is an empty string. I expect that result be `-24:01:00`. Also thanks for all the great work...

```javascript console.log(ssf.format('yyyy-mm', new Date('2023-01-01T00:00:00'))) ``` > 2023-01 => correct Change computer timezone to Alaska ```javascript console.log(ssf.format('yyyy-mm', new Date('2023-01-01T00:00:00'))) ``` > 2022-12 => INCORRECT Note that I tried to raise the...

import ssfPkg from 'ssf'; const { format } = ssfPkg; let s= format("yyyy.mm.dd. hh:mm:ss", 45779.201898148145); Throws an error, because it treats the "." date separator as decimal seperator Here is...

It must accept the "." as a standalone date formatting character. ``` function eval_fmt(fmt, v, opts, flen) { ... default: - if(",$-+/():!^&'~{}=€acfijklopqrtuvwxzP".indexOf(c) === -1) throw new Error('unrecognized character ' +...