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