Libreoffice ask to repair the file

[sandropigreco]

After repair the file works correctly. With Onlyoffice (linux) and Microsoft Excel (windows) there is no problem

I'm using libreoffice 24.8 under Archlinux system.

[meiMingle]

@sandropigreco If you can provide me with that file or the code, I'd be happy to help resolve this issue.

[sandropigreco]

Hi, thanks for your support.
This is the code and the attached excel file

os = new FileOutputStream(filename, true); Workbook wb = new Workbook(os, "MyApplication", "1.0"); wb.setGlobalDefaultFont("Arial", 15.5); wb.properties() .setTitle("title property") .setCategory("category property") .setSubject("subject property") .setKeywords("keywords property") .setDescription("description property") .setManager("manager property") .setCompany("company property") .setHyperlinkBase("hyperlinkBase property"); Worksheet ws = wb.newWorksheet("Sheet 1"); ws.value(0, 0, "title 1"); ws.value(0, 1, "title 2"); ws.value(0, 2, "title 3"); ws.freezePane(0, 1); ws.finish(); wb.finish(); wb.close();

excel.xlsx

[meiMingle]

OK, I'll check this out as soon as I have time

[leiblix]

I also have this problem. The error appears in the newer versions of LibreOffice, as version 24.2.4.2 had no issues. After updating to version 24.2.6.2, I observed similar behavior.

I believe the issue is not with the internal structure itself, but rather with the generation of the zip archive. When I extract the relevant Excel file and then rezip it using a standard Linux utility, the spreadsheet is no longer corrupted.

[leiblix]

I found out that the Apache POI library suffers from this too. It has been reported on the LibreOffice issue tracker here: https://bugs.documentfoundation.org/show_bug.cgi?id=163384.

[jkubos]

We have experienced the same behavior in Python openpyxl library. Version 3.1.4 produces bad output, 3.1.5 is OK. Unfortunately there is no changelog yet and I was't able to find issue which fixed it https://foss.heptapod.net/openpyxl/openpyxl/-/issues/?sort=updated_desc&state=closed&first_page_size=100.