Re: All my POI built Excel files are suddenly corrupt?
Dominik Stadler <[email protected]> Thu, 10 Oct 2024 18:46:16 +0200
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <CABdJj57-v-diaTfE4tNKM9o5nm49qJ0boNUx056yqYYZNV7OHA@mail.gmail.com> |
--000000000000b36f810624221c62 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, for me your test-file opens fine both in Excel (2407 - 17830.20210 Click-to-Run) and LibreOffice (Version: 7.4.7.2) on Windows, so may be related to the exact version of LibreOffice? Which one do you use? On Thu, Oct 10, 2024 at 2:34=E2=80=AFPM Andreas Reichel < [email protected]> wrote: > 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.xls= x > > Thank again for help and cheers > Andreas > > > > > --000000000000b36f810624221c62--