Bug 64980 - org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException
Summary: org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-13 16:20 UTC by Hari
Modified: 2020-12-30 22:11 UTC (History)
1 user (show)



Attachments
This is the original excel file that will be read by using POI without re-save. (62.64 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-12-13 16:20 UTC, Hari
Details
As the comparison, this is another original file that is generated from the same system as the error one. This file works just fine without any problem or exception. (361.09 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-12-13 16:24 UTC, Hari
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hari 2020-12-13 16:20:35 UTC
Created attachment 37604 [details]
This is the original excel file that will be read by using POI without re-save.

DETAIL: Exception when trying to read excel file (XLSX). The file seems fine, it also can be opened by using Ms. Excel without any problem.

WORK ARROUND SOLUTION: re-saving the excel file.

PROBLEM: Background job won't be able to re-save the excel files.
Comment 1 Hari 2020-12-13 16:24:25 UTC
Created attachment 37605 [details]
As the comparison, this is another original file that is generated from the same system as the error one. This file works just fine without any problem or exception.

The first attachment "37604: This is the original excel file that will be read by using POI without re-save." will produces error.

The second attachment works just fine.
Comment 2 Dominik Stadler 2020-12-30 18:04:18 UTC
The main [Content_Types.xml] in the .xlsx is not according to the spec in the broken file, it does not link to the shared-strings xml file as required.

Unfortunately both LibreOffice and Excel are "lenient" for many such cases and thus makes it actually harder for everyone else ...