Bug 62732 - xlsx output by POI 4.0.0 cannot be opened because file format or extension is not valid.
Summary: xlsx output by POI 4.0.0 cannot be opened because file format or extension is...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.0.0-FINAL
Hardware: PC All
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-18 11:42 UTC by Peng
Modified: 2018-09-19 10:26 UTC (History)
0 users



Attachments
corrupted output xlsx by using 4.0.0 (60 bytes, text/plain)
2018-09-18 12:52 UTC, Peng
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Peng 2018-09-18 11:42:56 UTC
With previous version 3.17 there is no problem with created .xlsx output. After upgrade to 4.0.0 the output .xlsx is corrupted and can not be opened anymore with the message "...file format or file extension is not valid...". Used java version is same: jdk1.8.0_172. 
My program uses a predefined xlsx as template, at run time this template will be populated with data from database.
Comment 1 PJ Fanning 2018-09-18 11:59:21 UTC
Hi Peng - could you upload a corrupted xlsx file so that we can check its format?
Comment 2 Peng 2018-09-18 12:52:00 UTC
Created attachment 36153 [details]
corrupted output xlsx by using 4.0.0
Comment 3 Peng 2018-09-18 13:00:00 UTC
(In reply to PJ Fanning from comment #1)
> Hi Peng - could you upload a corrupted xlsx file so that we can check its
> format?

Hi Fanning, the file is available for download under the given link from dropbox.
Thank you for your support.
Comment 4 Peng 2018-09-19 09:12:33 UTC
Comparing to version 3.17, jaxb-xxx.2.3.0 are now included in 4.0.0. Does this change may have to do with the mentioned issue?
Comment 5 PJ Fanning 2018-09-19 10:26:31 UTC
Jaxb build dependency is for Java 10 build.
It is unlikely to be causing your issue.
I no longer have M$ tools installed, so I'm not really in a position to debug what's up with your file. I can confirm that it doesn't load in LibreOffice, MacOS Numbers or Google Spreadsheets. I can't see anything obvious in the xlsx zip contents.