Re: All my POI built Excel files are suddenly corrupt?
Andreas Reichel <[email protected]> Thu, 10 Oct 2024 19:34:29 +0700
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Organization | manticore-projects Co. Ltd. |
| Message-ID | <27c871d84610f235b4dc151c35bcf7b583e5463d.camel@manticore-projects.com> |
--=-+XYUrh9mGauE5vrKSSGJ Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you for your feedback, Dominik. Please see my remarks incorporated below: On Thu, 2024-10-10 at 14:23 +0200, Dominik Stadler wrote: > > * It happens for me as well with your code snippet Any idea what causes it? > * It does not depend on the version of POI, all versions from 3.17 - > 5.3.0 > lead to the same We have been using every single version since 3.17 for many years and this code has been working fine before. The problem started to occur maybe 2-3 months ago. > * LibreOffice does not complain for the file For us, it seems to be the other way around: LibreOffice complains and repairs, while Excel (at least some version) seem to accept it. At this point I am suspecting LibreOffice itself more than POI (because on the Java Side nothing changed). Or maybe Common Compression lib? > * When I create a sheet as part of the code, the problem goes away We always have sheets and can rule this out. It seems like our problem is different =F0=9F=98=9E > Might this be the case in your application in some cases? Or is there > something else which is not covered in the test-case yet? I guess I will have to write a self containing simplified test case then. In the meantime, here is the test file: https://manticore-projects.com/download/manticore_7841765197550883476.xlsx Thank again for help and cheers Andreas --=-+XYUrh9mGauE5vrKSSGJ--