Formats with multiple leading 000s need to preserve these in the output #2581

Open
opened 2020-09-29 03:51:02 +00:00 by snoopyjc · 2 comments
snoopyjc commented 2020-09-29 03:51:02 +00:00 (Migrated from github.com)

Formats with multiple leading 000s need to preserve these in the output:

console.log(SSF.format('000.0', 1))
1.0  (Excel gives 001.0)
console.log(SSF.format('000.#', 1))
1.  (Excel gives 001.)
console.log(SSF.format('000.0', 1.2))
1.2  (Excel gives 001.2)
console.log(SSF.format('000.#', 1.2))
1.2  (Excel gives 001.2)
Formats with multiple leading 000s need to preserve these in the output: console.log(SSF.format('000.0', 1)) 1.0 (Excel gives 001.0) console.log(SSF.format('000.#', 1)) 1. (Excel gives 001.) console.log(SSF.format('000.0', 1.2)) 1.2 (Excel gives 001.2) console.log(SSF.format('000.#', 1.2)) 1.2 (Excel gives 001.2)
snoopyjc commented 2020-09-29 04:11:28 +00:00 (Migrated from github.com)

This is matching 'dec1'.

This is matching 'dec1'.
clement911 commented 2020-10-15 16:13:54 +00:00 (Migrated from github.com)

We're also running into this bug. It's a pretty basic format though, it's the first one we tried.

We're also running into this bug. It's a pretty basic format though, it's the first one we tried.
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#2581
No description provided.