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

New Issue

2020-10-13T20:30:02Z

snoopyjc commented

2020-10-13 20:30:02 +00:00

(Migrated from github.com)

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 Label

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#2596