SSF - format not supported #2695
Labels
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#2695
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
I have been using SSF in my project, and have run into this problem - when the format is "#,0" it seems to throw an error. That is a valid excel format.
Error: unsupported format |#,0|
Component: write_num_flt
Stack: at write_num_flt (ssf.js:498)
at write_num (ssf.js:616)
at eval_fmt (ssf.js:824)
at format (ssf.js:940)
Excel appears to be auto-correcting
#,0
to#,##0
. You can create a new file with(https://jsfiddle.net/c91Lotas/ live example) Excel 2019 en-US appears to treat it as number with thousands separator and zero decimal places
I can see that, but is the library going to support that?
It's an interesting question. The current approach is to stick the autocorrected formats in the main file processing library, but it probably should be added to the library.
could you refer me to the code relating to this?