Exponential format with an embedded string gives incorrect results #2583

New Issue

2020-09-29T22:28:38Z

snoopyjc commented

2020-09-29 22:28:38 +00:00

(Migrated from github.com)

Another odd one from valid.tsv.

console.log(SSF.format('0"abde".0"??"000E+00', 12.3456789))
12abde12.3??1.235E+01

Excel gives the correct answer:

1abde.2??346E+01

Another odd one from valid.tsv. console.log(SSF.format('0"abde".0"??"000E+00', 12.3456789)) 12abde12.3??1.235E+01 Excel gives the correct answer: 1abde.2??346E+01

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