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 <[email protected]> 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 <[email protected]<mailto:[email protected]>> > Reply-To: POI Users List <[email protected]<mailto:[email protected]>> > Date: Monday, July 10, 2017 at 11:48 AM > To: POI Users List <[email protected]<mailto:[email protected]>> > 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. >
