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

Andreas Reichel <[email protected]> Sat, 02 Nov 2024 07:52:53 +0700
Newsgroups gmane.comp.jakarta.poi.user
Organization manticore-projects Co. Ltd.
Message-ID <d6dea7d37834a8e4c1b9858b9467eab801e5df03.camel@manticore-projects.com>
--=-Qzws8KqWsAG85ksLdlWq
Content-Type: text/plain; charset="ISO-8859-15"
Content-Transfer-Encoding: quoted-printable

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?)=A0
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.=A0
>
> Greetings,
>
> we have migrated everything to =A0Zip64Mode [1]=A0AlwaysWithCompatibilit=
y
> [2]=A0and 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/or=
g/apache/commons/compress/archivers/zip/Zip64Mode.html#line-50

--=-Qzws8KqWsAG85ksLdlWq--