I have a spreadsheet in XLSX format that was generated by a python program. it turns out that the python program had left some invalid characters in the file. When I open the file in Excel, it at least tells me that there is a problem. Libre Office Calc just opens the file and silently tries to correct the problem, leaving lots of blank cells.

Is there a way to tell Calc to warn me if there is a problem opening the file?


Sorry for not answering the question directly, but IMHO a better approach would be to validate the XLSX files just after generation.

There are different offline and online validators available for both OOXML and ODF documents. To single out just two sites:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.