Joe Cool
Joe Cool
To fix this, don't include + or - in the numeric format unless proceeded by an "E".
The test case in oddities.json line 153 is also incorrect.
This is probably "no help", but my python version supports this format. See for yourself here: https://snoopyjc.org/ssf/
Can't you just parse it back out with a regex and then convert it to a float value?
@RPethani If you only need number (not date) results, try grabbing the value of `ostr` from https://github.com/SheetJS/ssf/blob/master/ssf.js#L824 - this is the number string before it's put back into the user's...
A similar issue occurs in Engineering notation (for both float and int inputs), where `10` with format `000E-0` should give `010E0` not `1.000E1`.
Yes this is a very complex area of Excel. I have this working in my python version: >>> from ssf import SSF >>> ssf = SSF() >>> ssf.format('[>=1000000]#,,\" M\";####.00', -12.3)...
Thanks! I will fix it and add more test cases. -joe Sent from my AT&T iPhone > On Oct 8, 2020, at 3:26 AM, SheetJSDev wrote: > > >...
Another simple case: console.log(SSF.format("?/16", 1.25)) Unsupported format error.
This one was difficult!! Found another bad test case in oddities.json: ["[Red]General ;[Blue]General\\ ;[Green]Generalp;[Yellow]General'", [50, "50 "],[0,"0p"],[-25,"-25 "],["foo","foo'"]], should be: ["[Red]General ;[Blue]General\\ ;[Green]Generalp;[Yellow]General'", [50, "50 "],[0,"0p"],[-25,"25 "],["foo","foo'"]],