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

Open
opened 2020-11-06 07:14:58 +00:00 by clement911 · 4 comments
clement911 commented 2020-11-06 07:14:58 +00:00 (Migrated from github.com)

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

Format string '#,##0.##########' throws error: unsupported format |#,##0.##########|
snoopyjc commented 2020-11-08 16:21:09 +00:00 (Migrated from github.com)

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

This is probably "no help", but my python version supports this format. See for yourself here: https://snoopyjc.org/ssf/
clement911 commented 2020-11-09 07:15:41 +00:00 (Migrated from github.com)

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

@snoopyjc I'm afraid it wouldn't help as we use the javascript version (in browser)
clement911 commented 2020-12-07 13:03:22 +00:00 (Migrated from github.com)

Is there any fixed planned for this one?

Is there any fixed planned for this one?
kurumpa commented 2021-09-02 18:28:10 +00:00 (Migrated from github.com)

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.

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.
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#2600
No description provided.