Dear All, this is still an issue. We got complains from a customer using MS Excel 2016 that now all the Excel files are corrupted and can NOT be repaired. So what we have now is:
- Zip64Mode.Always works with MS Excel 2016, but shows corruption with LibreOffice (although that will be repaired automatically) - Zip64Mode.AlwaysWithCompatibility shows corruption with MS Excel 2016 (can not be repaired?), but works flawlessly with LibreOffice All other programs like Gnumeric and GoogleSheets always worked. What would be the best way to test on various Excel versions? Is only 2016 affected? (I don't know where to get an Excel from for testing.) Best regards Andreas On 2024/11/02 00:52:53 Andreas Reichel wrote: > Good Morning All. > > Unfortunately we seem to have celebrated too early since we get now > reports from one single MS Excel user about corrupted files. > And now things become really messy: > > 1) what was the best way to test Excel files on Excel (various > versions?) > 2) why all of this just recently, what has really changed and causes > it? > > Best regards > Andreas > > > > On Mon, 2024-10-14 at 06:48 +0700, Andreas Reichel wrote: > > On Fri, 2024-10-11 at 10:30 +0000, PJ Fanning wrote: > > > The SXSSF default is Zip64Mode.Always. > > > > Greetings, > > > > we have migrated everything to Zip64Mode [1] AlwaysWithCompatibility > > [2] and this has solved our problem entirely. > > On the LibreOffice side nobody responded yet, so maybe it is safe and > > sound to switch POI's default Zip64Mode? > > > > Warm regards > > Andreas > > > > > [1] Zip64Mode > https://commons.apache.org/proper/commons-compress/apidocs/org/apache/commons/compress/archivers/zip/Zip64Mode.html > [2] AlwaysWithCompatibility > https://commons.apache.org/proper/commons-compress/apidocs/src-html/org/apache/commons/compress/archivers/zip/Zip64Mode.html#line-50 >
