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 😞

> 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




Reply via email to