Thank you.  I think the difference is that my local environment on Tomcat is 
using the Oracle JVM, while the environment where this is an issue is using the 
IBM JVM.  So the zip implementation must be different.

I will go ahead an open up a bug ticket.

Carl Buxbaum
Senior Software Architect
17 Rogers Street
Gloucester / Massachusetts / 01930 / USA
1-978-515-5128

Bamboo Rose
The only B2B marketplace powered by proven trade engines.
www.BambooRose.com<http://www.bamboorose.com/>

Join Bamboo Rose for STARS 2017, our user conference in Boston this October! 
Register 
Today!<https://www.eventbrite.com/e/stars-2017-bamboo-rose-user-conference-tickets-31684750943>

Make Retail. Fun. Connected. Easier. Smarter. Together. Better.


From: Andreas Beeker <kiwiwi...@apache.org<mailto:kiwiwi...@apache.org>>
Reply-To: POI Users List <user@poi.apache.org<mailto:user@poi.apache.org>>
Date: Monday, July 10, 2017 at 11:48 AM
To: POI Users List <user@poi.apache.org<mailto:user@poi.apache.org>>
Subject: Re: corruption in xlsx spreadsheet generated by poi?


If I create a ³corrupt² excel, unzip it, and then zip it back up (on my
mac using zip command), the resulting zip file opens without issue.  If a
colleague on Windows generates the same excel, and does the same  probably
using windup, the corruption remains.


Please check if you see a difference with zipinfo:
http://www.info-zip.org/mans/zipinfo.html

See below [1] - for your "Results (2).xlsx".

I think there was something with the compression method,
i.e. not all compression methods might be supported -
also defN = "deflate normal" sound like a default compression.
IIRC there's also a file in our test-corpus with some strange compression 
method,
which poi can't open.


Hmm, for some reason my attached files did not make it into the thread.  Is 
there a UI where I can attach them?
Just open a ticket in the bugzilla:
https://bz.apache.org/bugzilla/enter_bug.cgi?product=POI&component=XSSF


Andi


[1]

$ zipinfo Results2.xlsx
Archive:  Results2.xlsx
Zip file size: 6744 bytes, number of entries: 11
-rw----     2.0 fat      596 bl defN 17-Jul-06 10:02 _rels/.rels
-rw----     2.0 fat     1195 bl defN 17-Jul-06 10:02 [Content_Types].xml
-rw----     2.0 fat      184 bl defN 17-Jul-06 10:02 docProps/app.xml
-rw----     2.0 fat      441 bl defN 17-Jul-06 10:02 docProps/core.xml
-rw----     2.0 fat      131 bl defN 17-Jul-06 10:02 xl/drawings/drawing1.xml
-rw----     2.0 fat      138 bl defN 17-Jul-06 10:02 xl/sharedStrings.xml
-rw----     2.0 fat     3601 bl defN 17-Jul-06 10:02 xl/styles.xml
-rw----     2.0 fat      350 bl defN 17-Jul-06 10:02 xl/workbook.xml
-rw----     2.0 fat      574 bl defN 17-Jul-06 10:02 xl/_rels/workbook.xml.rels
-rw----     2.0 fat    22610 bl defN 17-Jul-06 10:02 xl/worksheets/sheet1.xml
-rw----     2.0 fat      303 bl defN 17-Jul-06 10:02 
xl/worksheets/_rels/sheet1.xml.rels
11 files, 30123 bytes uncompressed, 5226 bytes compressed:  82.7%



________________________________

DISCLAIMER: E-mails and attachments from Bamboo Rose, LLC are confidential. If 
you are not the intended recipient, please notify the sender immediately by 
replying to the e-mail, and then delete it without making copies or using it in 
any way. No representation is made that this email or any attachments are free 
of viruses. Virus scanning is recommended and is the responsibility of the 
recipient.

Reply via email to