sheetjs icon indicating copy to clipboard operation
sheetjs copied to clipboard

Format string '#,##0.##########' throws error: unsupported format |#,##0.##########|

Open clement911 opened this issue 4 years ago • 4 comments

Format string '#,##0.##########' throws error: unsupported format |#,##0.##########|

clement911 avatar Nov 06 '20 07:11 clement911

This is probably "no help", but my python version supports this format. See for yourself here: https://snoopyjc.org/ssf/

snoopyjc avatar Nov 08 '20 16:11 snoopyjc

@snoopyjc I'm afraid it wouldn't help as we use the javascript version (in browser)

clement911 avatar Nov 09 '20 07:11 clement911

Is there any fixed planned for this one?

clement911 avatar Dec 07 '20 13:12 clement911

Hey there, I might have come with a workaround, take a look: https://gist.github.com/kurumpa/4f06a0327852ff3dfcd01cf7b2d0e8ee It works about 5 times slower than the original formatter function, but I guess that's still fine for a decent amount of numbers to be formatted.

kurumpa avatar Sep 02 '21 18:09 kurumpa