sheetjs/sheetjs
41
Fork 43
Code Issues 201 Pull Requests 12 Wiki Activity

Import of file with long numbers (SSCC) is parsed wrong #3239

New Issue
Open
opened 2024-10-14 11:01:38 +00:00 by tamsrud · 2 comments
tamsrud commented 2024-10-14 11:01:38 +00:00
Copy Link

Importing of the attached excel file is parsed wrong. The numbers is changed. Attached screenshot of the excel file and how it is imported in the sheetjs in-browser demo.

Guessing it some rounding issues happening when the number is above a certain length.

Importing of the attached excel file is parsed wrong. The numbers is changed. Attached screenshot of the excel file and how it is imported in the sheetjs in-browser demo. Guessing it some rounding issues happening when the number is above a certain length.
SSCC test numbers.xlsx
9.3 KiB
excel file.png
6.3 KiB
sheetjs parsing.png
40 KiB
excel file.png sheetjs parsing.png
sheetjs commented 2024-10-14 13:23:41 +00:00
Owner
Copy Link

Excel limits numbers to 15 digits. There is a correction applied for date codes but it appears we also need to apply it to general numbers

Excel limits numbers to 15 digits. There is a correction applied for date codes but it appears we also need to apply it to general numbers
tamsrud commented 2024-10-15 10:34:16 +00:00
Author
Copy Link

Not sure if this can/should be fixed anyway. Since Excel has a 15 digit limit, having 18 digit numbers will always cause issues of some sort.

Not sure if this can/should be fixed anyway. Since Excel has a 15 digit limit, having 18 digit numbers will always cause issues of some sort.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
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 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
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
No Assignees
2 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#3239
No description provided.
Delete Branch "%!s()"

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?