Thank you so much PJ, you are my hero! Now everything starts making sense: On Wed, 2024-11-06 at 18:29 +0000, PJ Fanning wrote: > The code that zips sxssfworkbooks is basically this PR plus a few > changes. > https://github.com/apache/poi/pull/154 > > Zip64Mode.Always - the zip writing logic is mainly in the code in the > PR above with a bit of help from commons-compress.
I am using this and it seems to work in general but writes holes/un- used blocks as explained here: https://bugs.documentfoundation.org/show_bug.cgi?id=163384#c5 Since those holes can be filled with any arbitrary values it indeed looks like a bug in POI itself? > Any other Zip64Mode and the zip writing is done using commons- > compress but with the specific Zip64Mode applied. The Commons Compress files do not seem to have those holes and are accepted by LibreOffice. Unfortunately they fail in Excel (at least 2016) and we can't use those at all (since all our clients are Excel only). Thank you all for helping in cheers! Andreas
