Created a simple ods with libre office with a few non empty cells and got this
Testing D:\ODS1\TestCorpusV2\Valid\Simple.ods
APP-1: [INFO] Validating D:\ODS1\TestCorpusV2\Valid\Simple.ods.
APP-4: [INFO] Validation report for D:\ODS1\TestCorpusV2\Valid\Simple.ods.
DOC-3: mimetype [INFO] OpenDocument MIMETYPE application/vnd.oasis.opendocument.spreadsheet detected
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 3595: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 3778: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 3961: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4144: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4327: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4510: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4693: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4876: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 5059: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 5242: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 5425: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id".
NOT VALID, 11 errors, 0 warnings and 1 info messages.
Created a simple ods with libre office with a few non empty cells and got this
Testing D:\ODS1\TestCorpusV2\Valid\Simple.ods APP-1: [INFO] Validating D:\ODS1\TestCorpusV2\Valid\Simple.ods. APP-4: [INFO] Validation report for D:\ODS1\TestCorpusV2\Valid\Simple.ods. DOC-3: mimetype [INFO] OpenDocument MIMETYPE application/vnd.oasis.opendocument.spreadsheet detected XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 3595: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 3778: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 3961: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4144: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4327: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4510: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4693: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 4876: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 5059: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 5242: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". XML-4: content.xml [ERROR] Not a valid XML document. Validation exception at line 2 and column 5425: attribute "calcext:value-type" not allowed here; expected attribute "table:content-validation-name", "table:formula", "table:number-columns-repeated", "table:number-columns-spanned", "table:number-matrix-columns-spanned", "table:number-matrix-rows-spanned", "table:number-rows-spanned", "table:protect", "table:protected", "table:style-name", "xhtml:about", "xhtml:content", "xhtml:datatype", "xhtml:property" or "xml:id". NOT VALID, 11 errors, 0 warnings and 1 info messages.