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--