When Google Spreadsheets exports ODF documents, the resulting files fail XML validation. Specifically, I observed the following two classes of errors.
namespace has the wrong URN
. The ODF schema requires “urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0”. But Google Spreadsheets is writing out “http://www.w3.org/2000/svg
Several attributes which are typed as ID's have illegal values. For example style:name=“1col-Sheet1” or style:data-style-name=“N4,2cel-Sheet1”. An ID cannot start with a number, nor can it contain a comma.
Luckily, these should be very easy to fix. For example, the ID's could have a leading underscore, e.g., style:name=“_1col-Sheet1” and the comma could be replaced by an underscore, e.g., style:data-style-name=“N4_2cel-Sheet1”