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:r2cochr...@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 <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=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. > > >
