poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Cochran <r2cochr...@gmail.com>
Subject Re: corruption in xlsx spreadsheet generated by poi?
Date Tue, 11 Jul 2017 04:59:14 GMT
I'm not sure what the reference to "IBM JVM" really means in this context.
If one means "The Java Virtual Machine that runs under IBM System Z on a
z-Series mainframe", then character encoding issues to and from EBCDIC
could be a problem. IBM's Tier 1 implementation of the JVM (under Unix
System Services) is natively EBCDIC. It is just another possibility,

Thanks

Bob

On Mon, Jul 10, 2017 at 2:20 PM, Javen O'Neal <onealj@apache.org> wrote:

> 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