ODS parser bugs: same data and empty lines #328
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#328
Loading…
Reference in New Issue
Block a user
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?
I'm using js-xlsx on node.js and found a couple of bugs when parsing ODS files.
In any part of the spreadsheet, if there are two or more consecutive cells in a row with same data (and formatting, more on this below), only the first one gets correctly parsed: the following cells are treated as empty.
Example: if I have in the sheet:
I get:
Note that for the bug to occur the cells have to be also formatted in the same way. It can happen that cells with same data appear to be exactly the same but the formatting is someway different, for example a number with no formatting at all and another cell with same number but with number format.
After a first empty line, every following empty line is totally ignored (as if it didn't exist in the sheet file) and other following data lines have the row coordinate translated (subtracted) by an amount equal to the ignored empty lines.
Example:
I get:
The exact same .ods file exported as .xlsx (using Libre Office) gets correctly parsed and none of the above occurs.
Could someone please direct me on the right source file(s) in order to try to correct this issue? It's very important for the project I'm working on (where having the spreadsheet files in xlsx format is not an option).
Thanks,
Fabio
Hello, I've noticed this exact problem today too.
I noticed that the parser does not handle table:number-columns-repeated attributes in the content.xml.
It seems there is already a PR which solves this particular problem (see https://github.com/SheetJS/js-xlsx/pull/179), but I wonder if there is still someone managing this project...
Maybe we should try to find a fork...
Yes, sorry for late replay, maybe You're right, I'll look as soon as possible - and if you find a good fork please link it here ;-)
Cheers,
Fabio
its not fixed?