ODS export - corrupt file

Added by Matthew Leingang over 6 years ago

Salut,

This is an annoyance that has plagued me since I began using AMC several years ago, but I finally have some time to look into.

Every time I prepare an OpenOffice spreadsheet report (ODS), and open in OpenOffice, I get an error message: "The file '...' is corrupt and therefore cannot be opened. OpenOffice.org can try to repair the file. ... Should OpenOffice.org repair the file?"

I choose "Yes" and the file is eventually opened. Then I can save the repaired version.

I have similar problems when I try to read the ODS file in other programs via perl and python libraries. I am guessing there's an error in the ODS Export plugin somewhere.

I tried to compare the ODS files before and after repairing. Each ODS file is a zipped archive. The content.xml files in each are clearly different, but I can't isolate the material differences with the naked eye.

I've attached a small project as a ZIP archive. In exports/ I have both before and after ODS files. Note that I had to delete the processed files in scans/ to keep the zipfile small enough. But the original scanned PDFs are in there.

test2_0001.zip - Test project zip file (536.2 kB)

AMC-DEBUG-HivGx02m.log.saved - Test project log file (240.9 kB)


Replies (3)

RE: ODS export - corrupt file - Added by Alexis Bienvenüe over 6 years ago

My LibreOffice 6.0.5.1 does not tell me that the file is corrupted.
Which OpenOffice version do you use?

RE: ODS export - corrupt file - Added by Matthew Leingang over 6 years ago

I have OpenOffice.org 3.3.0 on my machine.

RE: ODS export - corrupt file - Added by Matthew Leingang over 6 years ago

I just installed LibreOffice 6.0.4.2 on my Mac, and it did open without a warning. I don't mind switching to LibreOffice, since it seems to be a much newer application.

I will check if programmatic parsing still fails.

(1-3/3)