https://issues.apache.org/bugzilla/show_bug.cgi?id=51444
--- Comment #3 from Yegor Kozlov <[email protected]> 2011-06-28 15:22:44 UTC --- (In reply to comment #2) > both files are created in libraoffice(former openoffice) > > yes I just saved it again as OpenXML file. > > Hmm, maybe there is a problem with OpenOffice implementation? > > Still how can I ensure I will not receive such a file from a third party? > (we try to process XLS and XLSX files sent from external sources, so we have > no > control over these files, how they are populated, etc) > And that file can be reopened in OpenOffice as a valid file. So it looks good. > > I wrote a workaround that copies XSSFworkbook, sheet by sheet, cell by cell, > so > I can manage so far, but it would be nice to have same solution both for XSL > and XLSX files It looks like POI has a problem re-saving files from LibreOffice. I suspect that the following differences in [Content_Types].xml cause it: LibreOffice: <Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types";> <Override PartName="/_rels/.rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/> <Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/> POI: <Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types";> <Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/> <Default Extension="xml" ContentType="application/xml"/> It might be that LibreOffice is correct and POI does not handle a specific OOXML case. I'm going to install LO and research it. Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
