poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javen O'Neal" <one...@apache.org>
Subject Re: corruption in xlsx spreadsheet generated by poi?
Date Mon, 10 Jul 2017 18:20:37 GMT
Sounds like this is a difference in incompatible zip library
implementations. POI uses java.util.zip.ZipFile, for which the JVM provides
the implementation.

There may be some hints that POI can provide to the JVM to get compatible
files on IBM Java. If not, this may be a bug in the JVMs not confirming to
the same zip spec.

On Jul 10, 2017 7:16 PM, "Robert Cochran" <r2cochran2@gmail.com> wrote:

Hi, does it make a difference that the Results2.xlsx file contains a
drawing1.xml? With the understanding that I myself am just learning how to
use the POI to generate Excel workbooks and sheet data.

Thanks

Bob Cochran
Greenbelt, Maryland


On Mon, Jul 10, 2017 at 12:33 PM, Carl Buxbaum <cbuxbaum@bamboorose.com>
wrote:

> 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