Bug 64980

Summary: org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException
Product: POI Reporter: Hari <hariiangg>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: normal CC: hariiangg
Priority: P2    
Version: 4.1.2-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: This is the original excel file that will be read by using POI without re-save.
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.

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 ...