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 Tue, 11 Jul 2017 12:42:33 GMT
IBM JVM refers to IBM's implementation  of the jvm. They have their own complete write of the
jvm, probably derived from openjdk.  As such, they have their own implementation of java.util.zip
classes.  on WebSphere, the default jvm to use is theirs. To use the Oracle jvm, one has to
install and specify it.

Carl

Get Outlook for Android<https://aka.ms/ghei36>

________________________________
From: Murphy, Mark <murphymdev@metalexmfg.com>
Sent: Tuesday, July 11, 2017 8:21:26 AM
To: 'POI Users List'
Subject: RE: corruption in xlsx spreadsheet generated by poi?

I believe that the JVM still uses Unicode internally. I believe character data is probably
converted when the string is created. I know that on IBM i, I do not have to do anything special
to EBCDIC character data, and POI documents are written correctly.

-----Original Message-----
From: Robert Cochran [mailto:r2cochran2@gmail.com]
Sent: Tuesday, July 11, 2017 12:59 AM
To: POI Users List <user@poi.apache.org>
Subject: Re: corruption in xlsx spreadsheet generated by poi?

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=X
> > SSF
> >
> >
> > 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.
> >
>
B�KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKCB��[��X��ܚX�KK[XZ[�\�\�][��X��ܚX�P�K�\X�K�ܙ�B��܈Y][ۘ[��[X[��K[XZ[�\�\�Z[�K�\X�K�ܙ�B
________________________________

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.
________________________________

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