Re: All my POI built Excel files are suddenly corrupt?

[Andreas Reichel]

On Thu, 2024-10-10 at 23:03 +0000, PJ Fanning wrote:
> workBook.setZip64Mode(Zip64Mode.Never);
>
> Some tools may not be able to handle Zip64 mode.

You are my hero! The following works and no corruption.
Please don't allow/set Zip64Mode.Never, it will hang forever and is
hard to kill.

Now, who is to blame and where to report this problem to? Is is Commons
Compress or LibreOffice?

Thank you so much for the hint and help!

public class Main {
    public static void main(String[] args) {
        // this will cause corruption
        SXSSFWorkbook wb  = new SXSSFWorkbook(new XSSFWorkbook(), 100, true, 
true);
        SXSSFSheet sheet = wb.createSheet("test");
        wb.setZip64Mode(Zip64Mode.AlwaysWithCompatibility);

        File outputFile = null;
        try {
            outputFile = File.createTempFile("poitest_", ".xlsx");
            FileOutputStream fileOutputStream = new 
FileOutputStream(outputFile);
            wb.write(fileOutputStream);
            wb.close();
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }
}