Fixed-point formatting of small or large numbers gives incorrect results #2596

opened 2020-10-13 20:30:02 +00:00 by snoopyjc · 0 comments
snoopyjc commented 2020-10-13 20:30:02 +00:00 (Migrated from

SSF.format('0.0000000', 0.0000001) gives 1e-7.0000000 instead of 0.0000001.

SSF.format('#.0', 1E30) gives 1e+30.0 instead of 1000000000000000000000000000000.0

`SSF.format('0.0000000', 0.0000001)` gives `1e-7.0000000` instead of `0.0000001`. `SSF.format('#.0', 1E30)` gives `1e+30.0` instead of `1000000000000000000000000000000.0`
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.


No dependencies set.

Reference: sheetjs/sheetjs#2596
No description provided.