poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Buxbaum <cbuxb...@bamboorose.com>
Subject Re: corruption in xlsx spreadsheet generated by poi?
Date Mon, 10 Jul 2017 16:33:33 GMT
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 <kiwiwings@apache.org<mailto:kiwiwings@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.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message