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 <one...@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" <r2cochr...@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 <cbuxb...@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 <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. > > >