On Fri, 2024-10-11 at 00:47 +0000, PJ Fanning wrote: > The idea is that the Zip64 mode is only needed for big files and > SXSSF is for big files. > XSSF could have the support added too but it hasn't been a priority. > In theory, we could add it to all the poi-ooxml doc types.
Thank you for the explanation. Although in my opinion, this idea has a major flaw: The java program (like a reporting application) can't really know if the file would be "big" -- and the needed code paths are very different. So in my opinion, at least for "Writing reports", the SXSSF should be the default approach from the perspective of performance and also memory consumption -- unless features (like formulas, inserting rows etc.) dictate otherwise. Am I right to understand, that XSSF never uses Zip64 and SXSSF uses it "AsNeeded" (per default)? If so, then why for my sample code "NEVER" will completely break LibreOffice? I would have thought that NEVER produces same file as XSSF output? And why am I always the only one with such problems 😄 Cheers Andreas
